Product 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.

Product Details

• Amazon Sales Rank: #192126 in Books
• Published on: 2004-12-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 456 pages

Customer Reviews

Solid book, briefing you on the many areas a DBA needs
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.