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

1. An Overview
2. BEA Tuxedo: PeopleSoft’s Application Server Technology
3. Database Connectivity
4. PeopleSoft Database Structure: A Tale of Two Data Dictionaries
5. Keys and Indexing
6. PeopleSoft DDL
7. Tablespaces
8. Locking, Transactions, and Concurrency
9. Performance Metrics
10. PeopleSoft Performance Utilities
11. SQL Optimization Techniques in PeopleSoft
12. Configuring the Application Server
13. Tuning the Application Server
14. The Process Scheduler