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
- Title Page
- Contents at a Glance
- Contents
- Foreword
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- CHAPTER 1: An Overview
- CHAPTER 2: BEA Tuxedo: PeopleSoft's Application Server Technology
- CHAPTER 3: Database Connectivity
- CHAPTER 4: PeopleSoft Database Structure: A Tale of Two Data Dictionaries
- CHAPTER 5: Keys and Indexing
- CHAPTER 6: PeopleSoft DDL
- CHAPTER 7: Tablespaces
- CHAPTER 8: Locking, Transactions, and Concurrency
- CHAPTER 9: Performance Metrics
- CHAPTER 10: PeopleTools Performance Utilities
- CHAPTER 11: SQL Optimization Techniques in PeopleSoft
- CHAPTER 12: Configuring the Application Server
- CHAPTER 13: Tuning the Application Server
- CHAPTER 14: The Process Scheduler
- Index
Product information
- Title: PeopleSoft for the Oracle DBA
- Author(s):
- Release date: November 2004
- Publisher(s): Apress
- ISBN: 9781590594223
You might also like
book
PeopleSoft for the Oracle DBA
PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and …
book
Pro Oracle GoldenGate for the DBA
Take a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective …
book
Pro Oracle Database 12c Administration, Second Edition
Pro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from …
book
Oracle RMAN Database Duplication
RMAN is Oracle’s flagship backup and recovery tool, but did you know it’s also an effective …