PeopleSoft for the Oracle DBA

This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft system.

Ur innehållet:

Chapter 1: Architecture Overview

Chapter 2: BEA Tuxedo, PeopleSoft’s Application Server

Chapter 3: PeopleSoft database Structure: A Tale of two Data Dictionaries

Chapter 4: Database Connectivity

Chapter 5: Keys & Indexing

Chapter 6: PeopleSoft DDL

Chapter 7: Tablespaces

Chapter 8: Database Privileges of PeopleSoft Schemas

Chapter 9: Performance Metrics

Chapter 10: PeopleSoft Performance Monitoring Utilities

Chapter 11: SQL Optimization Techniques in PeopleSoft

Chapter 12: Tuxedo Configuration and Tuning

Chapter 13: Tuxedo Utilities

Chapter 14: Tuxedo Webserver