PeopleSoft for the Oracle DBA

2nd Edition

By David Kurtz

PeopleSoft for the Oracle DBA Cover Image

PeopleSoft for the Oracle DBA provides the help database administrators need to manage and troubleshoot PeopleSoft as deployed atop an Oracle Database.

Full Description

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

Related Titles

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.

Errata

Please Login to submit errata.

No errata are currently published