NEWS: (28.10.2006) The PeopleSoft DBA blog (www.psftdba.blogspot.com) continues to grow.  I am using it for material that would otherwise appear as addenda to the book.  Recent work on PeopleTools 8.48 has produce a number of new items and addenda.

• (20.4.2007) I am in discussions with Oracle University about running a PeopleSoft seminar in Israel.  If you would be interested in this please let me know and I will tell Oracle.
• (1.5.2007) I have had a number of approaches to run seminars in North America.  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.

© Go-Faster Consultancy Ltd. 2007