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

NEWS: The PeopleSoft DBA blog (blog.psftdba.com) continues to grow. I am using it for material that would otherwise appear as addenda to the book. Recent work on continues to produce new items and addenda.

Recent blog posts:

Applying Hints to Objects inside Database Views (28.6.2011)

Deferred Segment Creation in PeopleSoft (26.6.2011)

Unlocking Temporary Table Instances from Deleted Process Requests (17.2.2011)

Finding Unnecessary Effective Date Processing in PS/Query (19.1.2011)

Row Level Locking in the PeopleTools Component Processor (18.1.2011)

(31.3.2010) Latest addenda:

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

(1.7.2008) 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'!

PeopleSoft for the Oracle DBA was published by Apress in November 2004 and is available as a part of their Oak Table press series.

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:

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.