A PeopleSoft Survival Guide for DBAs and other technicians
A part of the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. It provides answers to common questions that arise when using PeopleSoft on an Oracle database.
The book begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Subsequent chapters explain database structures, connectivity, keys and indexing, the PeopleSoft DDL generation, tablespaces organisation, performance metrics, performance monitoring utilities, and SQL optimization techniques.