PeopleSoft for the Oracle DBA

Paperback
from $0.00

Author: David Kurtz

ISBN-10: 1590594223

ISBN-13: 9781590594223

Category: Business Software

Search in google:

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.

Ch. 1An overview1Ch. 2BEA Tuxedo : PeopleSoft's application server technology15Ch. 3Database connectivity31Ch. 4PeopleSoft database structure : a tale of two data dictionaries55Ch. 5Keys and indexing87Ch. 6PeopleSoft DDL115Ch. 7Tablespaces149Ch. 8Locking, transactions, and concurrency163Ch. 9Performance metrics171Ch. 10PeopleTools performance utilities229Ch. 11SQL optimization techniques in PeopleSoft263Ch. 12Configuring the application server315Ch. 13Tuning the application server359Ch. 14The process scheduler387