You are previewing PeopleSoft for the Oracle DBA.
O'Reilly logo
PeopleSoft for the Oracle DBA

Book 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 David Kurtz is a field expert and 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. The final chapters provide crucial, advanced information about Tuxedo.

Table of Contents

  1. Title Page
  2. Contents at a Glance
  3. Contents
  4. Foreword
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. 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
  9. 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
  10. 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
  11. CHAPTER 3: Database Connectivity
    1. PeopleSoft Database vs. Oracle Database
    2. Oracle Database Users
    3. Oracle Database Roles
    4. Signing On to a PeopleSoft 8 Database
    5. Signing On to a PeopleSoft 7.5 Database
    6. Connecting Third-Party Applications
    7. Changing Database Passwords
    8. Summary
  12. CHAPTER 4: PeopleSoft Database Structure: A Tale of Two Data Dictionaries
    1. Two Data Dictionaries
    2. Recursive PeopleTools SQL
    3. Data Dictionary Synchronization
    4. Summary
  13. 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
  14. CHAPTER 6: PeopleSoft DDL
    1. PeopleSoft DDL and the DBA
    2. DDL Models
    3. Overriding DDL Model Defaults
    4. PeopleTools Tables
    5. DDL Model Enhancements
    6. Limitations of PeopleSoft DDL Models
    7. Other DDL
    8. Synchronizing PeopleSoft with the Oracle Catalogue
    9. Summary
  15. CHAPTER 7: Tablespaces
    1. Database Creation
    2. Managing Tablespaces for PeopleSoft
    3. Summary
  16. CHAPTER 8: Locking, Transactions, and Concurrency
    1. Locking
    2. PIA Transactions
    3. Sequence Numbers and Concurrency
    4. Summary
  17. CHAPTER 9: Performance Metrics
    1. Online Monitoring and Metrics
    2. Batch Metrics
    3. PeopleSoft Trace Files
    4. Summary
  18. CHAPTER 10: PeopleTools Performance Utilities
    1. Query Metrics in PeopleTools 8.4
    2. PeopleSoft Ping
    3. Performance Monitor
    4. Summary
  19. CHAPTER 11: SQL Optimization Techniques in PeopleSoft
    1. Enabling Oracle SQL Trace
    2. Where Does This SQL Come From?
    3. Techniques for SQL Optimization
    4. Implementing SQL Optimization Techniques
    5. Summary
  20. 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
  21. CHAPTER 13: Tuning the Application Server
    1. Sizing
    2. Other Tuxedo Options
    3. Other Tips
    4. Summary
  22. CHAPTER 14: The Process Scheduler
    1. Process Scheduler Architecture
    2. DBA Issues
    3. Summary
  23. Index