Description:

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.

 

Table of Contents:

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