Mar 02, 2012 |
2,697 views |

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 Download Now »
Sep 08, 2009 |
4,376 views |

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, Kurtz, is a field expert and thus, 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. And the final chapters provide crucial, advanced information about Tuxedo.
About the Author
Having studied physics at UCL, David Kurtz was introduced to Oracle in 1989 and spent 6 years in a software house as an Oracle Developer/DBA, working on assurance and insurance software. In 1996, Kurtz joined PeopleSoft in the UK, starting out in support and gradually moving into consultancy over several years. Since there was virtually no internal documentation about how PeopleSoft related to the database, Kurtz began learning it by himself. This led to fixing performance problems in PeopleSoft systems. Soon enough, Kurtz was spending all of his time on performance-related consultancy. Download Now »