PeopleSoft for the Oracle DBA - A PeopleSoft Survival Guide for Oracle DBAs!

NEWS: The PeopleSoft DBA blog (blog.psftdba.com) has been quiert for a while befause I had been working on the 2nd edition of the book. However, there is work in the pipeline that will be published soon.

Recent blog posts:

PeopleTools 8.52 Application Engine sets MODULE and ACTION (23.11.2012)

Using Two Temporary Tablespaces in PeopleSoft (16.11.2012)

Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g (30.9.2012)

Enabling Oracle Extended SQL Trace by Module and Action (20.9.2012)

Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects (19.7.2012)

(31.3.2010) Latest addenda:

Chapter 11: Exceptions to comments on Stored Outlines: (31.3.2010)

(11.5.2012) I have had a number of approaches to run seminars in various locations, but the problem is critical mass. However, if you are interested please let me know.

Read 'an unqualified positive review' of the first edition!

The second edition of PeopleSoft for the Oracle DBA was published by Apress in February 2012.

This book is a survival guide for the Oracle DBA, or any other technician, who is charged with responsibility for the configuration, administration and performance of a PeopleSoft ERP system. The database is at core of any ERP system, but a DBA must also understand how the PeopleSoft application is using the database, and how our parts of the PeopleSoft architecture interact with the database. The book:

Described the PeopleSoft technical architecture and how it relates to the Oracle database.
Demonstrates how to effectively implement common Oracle database administration techniques and strategies (indexing, DDL, managing tablespaces and so on) specifically for a PeopleSoft system, and using the PeopleSoft toolset
Shows how to analyze application activity, and obtain the critical data that will allow you to track down the causes of poor performance.
Provides essential details on the configuration and tuning of the Tuxedo application server that works with the database

This book is a reflection of what I've been doing most days for many years: helping PeopleSoft customers get sufficient performance out of their systems to support their businesses. It provides the answers to the questions that I am still repeatedly asked by DBAs, Developers and end-users about what is going on inside their PeopleSoft system, such as:

How do I measure what part of the application response time is spent in which tier of the system, and thus determine whether the database or another tier is the most significant performance issue?
Who is running this piece of SQL, where does it come from, and what can I do about it?
What changes can I safely make to the system, via the PeopleSoft development tools and without creating an administrative nightmare?

Ultimately, it’s about how an Oracle DBA should work with PeopleSoft instead of continually fighting against it.