PeopleSoft for the Oracle DBA (Oaktable Press)
$61.95 (includes GST)
Paperback package 456
20%Off Retail Price
Usually ships within 3-5 business days.
N.Sydney : On Order (reserve your copy)
| Add to Shopping Cart
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.
David Kurtz - 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.
Kurtz left PeopleSoft in 2000 and set up Go-Faster Consultancy Ltd. (http://www.go-faster.co.uk), providing performance and technical consultancy to PeopleSoft users. Since then, Kurtz has learned to apply principles of wait-based tuning to the database and to the PeopleSoft layers atop the database. Kurtz has been a member of the UK Oracle User Group since 1994 and became chairman of the UNIX SIG in 2000. He presents regularly at PeopleSoft and UKOUG conferences and SIG meetings. After a roundtable discussion at a PeopleSoft conference in 2002, Kurtz started the lively PeopleSoft DBA Forum on Yahoo!, http://groups.yahoo.com/group/psftdba/.
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