PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.

You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.

Explains PeopleSoft’s technical architecture as it relates to Oracle Database
Demonstrates how to instrument and measure the performance of PeopleSoft
Provides techniques to troubleshoot and resolve performance problems

What you’ll learn

Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
Measure performance of the various tiers in the application
Pinpoint and resolve performance problems within the code
Configure server processes for optimal performance
Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager
Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44

Who this book is for

PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.
Table of Contents

An Overview
BEA Tuxedo: PeopleSoft’s Application Server Technology
Database Connectivity
PeopleSoft Database Structure: A Tale of Two Data Dictionaries
Keys and Indexing
PeopleSoft DDL
Tablespaces
Locking, Transactions, and Concurrency
Performance Metrics
PeopleSoft Performance Utilities
SQL Optimization Techniques in PeopleSoft
Configuring the Application Server
Tuning the Application Server
The Process Scheduler