PeopleSoft for the Oracle DBA / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $8.04
Usually ships in 1-2 business days
(Save 85%)
Other sellers (Paperback)
  • All (12) from $8.04   
  • New (7) from $34.68   
  • Used (5) from $8.04   


PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database.This new edition of David Kurtz'sbook is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.

You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft.Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.

  • Explains PeopleSoft’s technical architecture as it relates to Oracle Database
  • Demonstrates how to instrument and measure the performance of PeopleSoft
  • Provides techniques to troubleshoot and resolve performance problems

What you’ll learn

  • Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
  • Measure performance of the various tiers in the application
  • Pinpoint and resolve performance problems within the code
  • Configure server processes for optimal performance
  • Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager
  • Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44

Who this book is for

PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.

Table of Contents

  1. An Overview
  2. BEA Tuxedo: PeopleSoft’s Application Server Technology
  3. Database Connectivity
  4. PeopleSoft Database Structure: A Tale of Two Data Dictionaries
  5. Keys and Indexing
  6. PeopleSoft DDL
  7. Tablespaces
  8. Locking, Transactions, and Concurrency
  9. Performance Metrics
  10. PeopleSoft Performance Utilities
  11. SQL Optimization Techniques in PeopleSoft
  12. Configuring the Application Server
  13. Tuning the Application Server
  14. The Process Scheduler

Read More Show Less

Product Details

  • ISBN-13: 9781590594223
  • Publisher: Apress
  • Publication date: 11/24/2004
  • Edition description: 2005
  • Edition number: 1
  • Pages: 456
  • Product dimensions: 0.93 (w) x 7.50 (h) x 9.25 (d)

Meet the Author

David Kurtz began working with version 5.1 of the Oracle database in 1989 in a small software house as an Oracle developer/database administrator working on assurance and insurance software. In 1996, he joined PeopleSoft U.K., starting out in support and gradually moving into consultancy over several years. Since there was virtually no internal documentation about how PeopleSoft related to the database, he started by working out the relationship between the application and database for himself. This led to fixing performance problems in PeopleSoft systems. Soon enough, David was spending all of his time on performance-related consultancy.

David left PeopleSoft in 2000 to go into business for himself as Go-Faster Consultancy Ltd. ( There, he provides performance and technical consultancy, mostly to PeopleSoft users, mostly on Oracle. Since then, Kurtz has learned to apply principles of response-based performance, not just to the database, but holistically to the entire application stack.

David has been a member of the U.K. Oracle User Group since 1994. He chaired the UNIX SIG between 2000 and 2006, and serves on the board of directors. He presents regularly at PeopleSoft and Oracle conferences and meetings. David is a member of the OakTable Network ( and is also an Oracle ACE Director.

David started the lively PeopleSoft DBA Forum on Yahoo!( following a roundtable discussion at a PeopleSoft conference in 2002, and it continues to be a valuable resource. He writes two blogs: PeopleSoft ( and exclusively Oracle database (

Read More Show Less

Table of Contents

Ch. 1 An overview 1
Ch. 2 BEA Tuxedo : PeopleSoft's application server technology 15
Ch. 3 Database connectivity 31
Ch. 4 PeopleSoft database structure : a tale of two data dictionaries 55
Ch. 5 Keys and indexing 87
Ch. 6 PeopleSoft DDL 115
Ch. 7 Tablespaces 149
Ch. 8 Locking, transactions, and concurrency 163
Ch. 9 Performance metrics 171
Ch. 10 PeopleTools performance utilities 229
Ch. 11 SQL optimization techniques in PeopleSoft 263
Ch. 12 Configuring the application server 315
Ch. 13 Tuning the application server 359
Ch. 14 The process scheduler 387
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted December 21, 2004

    suddenly much more relevant

    It is impossible to analyse this book while ignoring the takeover last week of PeopleSoft by Oracle. Unless something strange happens, that is a done deal. So either the entire raison d'etre for the book has vanished, or it has suddenly taken on new urgency. Over a year ago, when Oracle first announced its bid, Ellison said they only wanted PeopleSoft's customers. Gosh. No need for this book then. But after much to-do, Oracle 'pledged' to 'over-support' the customers. Now, it looks like a lot of Oracle DBAs are going to need this book, to understand integrating the two databases. Another audience for the book has also emerged. Current PeopleSoft DBAs. At least the smarter ones. Because this book is about the PeopleSoft database, as seen from the perspective of Oracle. Of course, a PeopleSoft DBA now needs to quickly learn Oracle [from other texts]. But it is also prudent to see your database from the Oracle side, since that is going to be the dominant view, going forward. Realistically, in the long run, Oracle is going to merge the two databases. Guess which will dominate? Right now, you may have some job security, inasmuch as that merging will take years, and Oracle needs blokes to maintain the PeopleSoft databases. By the way, it is not just employees of PeopleSoft who should do this. If you are a DBA in some company that is currently using PeopleSoft, consider carefully the previous suggestion.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)