Peoplesoft For The Oracle Dba

Written by a field expert, this training manual answers common questions and misunderstandings pertaining to Oracle DBAs and PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries.

The newest addition to 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. Author, Kurtz, is a field expert and thus, provides answers to common questions that arise when using PeopleSoft on an Oracle database.

Kurtz begins the book with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Kurtz transitions smoothly between subsequent chapters, explaining database structures, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces. Kurtz gives appropriate weight to advanced topics as well, like schemas, performance metrics, performance monitoring utilities, and SQL optimization techniques. And the final chapters provide crucial, advanced information about Tuxedo.