People Soft for the Oracle DBA, Second Edition stands on the boundary between the People Soft 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 People Soft environment.
You’ll learn about People Soft’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 People Soft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a People Soft environment. The solid coverage of performance troubleshooting is enough by itself to make People Soft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a People Soft environment.
- Explains People Soft’s technical architecture as it relates to Oracle Database
- Demonstrates how to instrument and measure the performance of People Soft
- Provides techniques to troubleshoot and resolve performance problems
Table of Content
An Overview
BEA Tuxedo: People Soft’s Application Server Technology
Database Connectivity
People Soft Database Structure: A Tale of Two Data Dictionaries
Keys and Indexing
People Soft DDL
Tablespaces
Locking, Transactions, and Concurrency
Performance Metrics
People Soft Performance Utilities
SQL Optimization Techniques in People Soft
Configuring the Application Server
Tuning the Application Server
The Process Scheduler
About the author
David Kurtz began working with version 5.1 of the Oracle database in 1989 in a small software house as an Oracle developer/database administrator working on assurance and insurance software. In 1996, he joined People Soft U.K., starting out in support and gradually moving into consultancy over several years. Since there was virtually no internal documentation about how People Soft related to the database, he started by working out the relationship between the application and database for himself. This led to fixing performance problems in People Soft systems. Soon enough, David was spending all of his time on performance-related consultancy. David left People Soft in 2000 to go into business for himself as Go-Faster Consultancy Ltd. (http://Go-Faster.co.uk). There, he provides performance and technical consultancy, mostly to People Soft users, mostly on Oracle. Since then, Kurtz has learned to apply principles of response-based performance, not just to the database, but holistically to the entire application stack. David has been a member of the U.K. Oracle User Group since 1994. He chaired the UNIX SIG between 2000 and 2006, and serves on the board of directors. He presents regularly at People Soft and Oracle conferences and meetings. David is a member of the Oak Table Network (Oak Table.net) and is also an Oracle ACE Director. David started the lively People Soft DBA Forum on Yahoo!(http://groups.yahoo.com/group/psftdba) following a roundtable discussion at a People Soft conference in 2002, and it continues to be a valuable resource. He writes two blogs: People Soft (http://blog.psftdba.com) and exclusively Oracle database (http://blog.go-faster.co.uk).