on 31 December 2004
Dave Kurtz has put together the knowledge that he has gathered about installing and performance tuning a PeopleSoft system that uses Oracle. If you are an Oracle DBA running PSoft then this book is for you. It covers versions 7.5 through to 8.44 and has considerable background info about how PeopleSoft uses the web server, Tuxedo and (of course) the Oracle database.
The book covers performance troubleshooting in some depth - showing how to check each tier's performance. This includes some basics of web server tuning, the intricacies of the application server and the link between the SQL used on the database and how PeopleCode and queries are written. Here the book crosses over briefly and would be useful to developers too.
The main area that I would have liked to see more on would be the regular maintenance jobs that a DBA will need to do to keep a PeopleSoft system up and running e.g. which items should be checked on a regular basis, back ups, audits, managing upgrades.