Apress Access

PeopleSoft for the Oracle DBA

2nd Edition

By David Kurtz

  • eBook Price: $45.99
Buy eBook Buy Print Book
PeopleSoft for the Oracle DBA provides the help database administrators need to manage and troubleshoot PeopleSoft as deployed atop an Oracle Database.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-3707-5
  • 548 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: January 31, 2012
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Oracle Application Express Administration
  • Expert Oracle Indexing and Access Paths, 2nd Edition
  • Pro Oracle GoldenGate for the DBA
Full Description

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's book 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

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
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Practical Oracle Database Appliance


      View Book

    2. Protecting Oracle Database 12c


      View Book

    3. Expert Oracle Exadata


      View Book

    4. Oracle RMAN Database Duplication


      View Book