PeopleSoft for the Oracle DBA

PeopleSoft for the Oracle DBA

by David Kurtz
Released January 2012
Publisher(s): Apress
ISBN: 9781430237075

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book 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

  1. Title
  2. Contents at a Glance
  3. Contents
  4. Author's Preface to the Second Edition
  5. Foreword to the First Edition
  6. About the Author
  7. About the Technical Reviewers
  8. Acknowledgments
  9. Introduction
    1. Who Should Read This Book?
    2. What Does This Book Cover?
    3. Software Versions
    4. Other Resources
    5. Online Resources for This Book
    6. Contacting the Author
  10. Chapter 1: An Overview
    1. What Is PeopleSoft?
    2. Components of a PeopleSoft System
    3. Evolution of the PeopleSoft Architecture
    4. Developing and Administering PeopleSoft Systems
    5. Summary
  11. Chapter 2: BEA Tuxedo: PeopleSoft's Application Server Technology
    1. What Is Tuxedo?
    2. The Simple Application Server
    3. Anatomy of the Application Server
    4. Summary
  12. Chapter 3: Database Connectivity
    1. PeopleSoft Database versus Oracle Database
    2. Oracle Database Users
    3. Oracle Database Roles
    4. Signing On to a PeopleSoft 8 Database
    5. PeopleSoft Support for Oracle Active Data Guard
    6. Connecting Third-Party Applications
    7. Changing Database Passwords
    8. Summary
  13. Chapter 4: PeopleSoft Database Structure: A Tale of Two Data Dictionaries
    1. Application and PeopleTools Tables
    2. Two Data Dictionaries
    3. Recursive PeopleTools SQL
    4. Data Dictionary Synchronization
    5. Summary
  14. Chapter 5: Keys and Indexing
    1. What Is the Purpose of an Index?
    2. What Is a Constraint?
    3. What Is the Purpose of a Unique Constraint?
    4. Record Field Key Attributes
    5. Other Index Issues
    6. Summary
  15. Chapter 6: PeopleSoft DDL
    1. PeopleSoft DDL and the DBA
    2. DDL Models
    3. Overriding DDL Model Defaults
    4. PeopleTools Tables
    5. PSRECTBLSPC: Record Tablespace Allocation
    6. DDL Model Enhancements
    7. Extra Parameters with the Default DDL Model
    8. Limitations of PeopleSoft DDL Models
    9. Other DDL
    10. Synchronizing PeopleSoft with the Oracle Data Dictionary
    11. Summary
  16. Chapter 7: Tablespaces
    1. Database Creation
    2. Managing Tablespaces for PeopleSoft
    3. Summary
  17. Chapter 8: Locking, Transactions, and Concurrency
    1. Locking
    2. PIA Transactions
    3. Sequence Numbers and Concurrency
    4. Summary
  18. Chapter 9: Performance Metrics
    1. Online Monitoring and Metrics
    2. Batch Metrics
    3. PeopleSoft Trace Files
    4. Summary
  19. Chapter 10: PeopleTools Performance Utilities
    1. Query Metrics in PeopleTools 8.4
    2. PeopleSoft Ping
    3. Performance Monitor
    4. Performance Tuning the Performance Monitor
    5. Performance Monitor Case Study: Diagnosing a SQL Performance Problem
    6. Summary
  20. Chapter 11: SQL Optimization Techniques in PeopleSoft
    1. Active Session History
    2. Statspack
    3. Using Oracle Extended SQL Trace with PeopleSoft
    4. Where Does This SQL Come From?
    5. Techniques for SQL Optimization
    6. Implementing SQL Optimization Techniques
    7. Summary
  21. Chapter 12: Configuring the Application Server
    1. Overview of Configuration Files
    2. psappsrv.ubx
    3. Psappsrv.cfg
    4. psappsrv.val
    5. psappsrv.ubb
    6. psappsrv.env
    7. Configuration Template Files
    8. Tuxedo Administration Console
    9. Summary
  22. Chapter 13: Tuning the Application Server
    1. Sizing
    2. Other Tuxedo Options
    3. Other Tips
    4. Summary
  23. Chapter 14: The Process Scheduler
    1. Process Scheduler Architecture
    2. DBA Issues
    3. Summary
  24. Index

Product information

  • Title: PeopleSoft for the Oracle DBA
  • Author(s): David Kurtz
  • Release date: January 2012
  • Publisher(s): Apress
  • ISBN: 9781430237075