PeopleSoft for the Oracle DBA (Oaktable Press) (Paperback)

by David Kurtz (Author)
Key Phrases: data mover, spawn server, global temporary tables, Application Designer, Max Instances, Min Instances (more...)

Editorial Reviews

Product Description
<p>The newest addition to the <b> OakTable Press </b> series, <i> PeopleSoft for the Oracle DBA, </i> 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. <p>

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. <p>

Kurtz left PeopleSoft in 2000 and set up Go-Faster Consultancy Ltd.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.

Product Details

• Paperback: 456 pages
• Publisher: Apress; 1 edition (September 18, 2008)
• Language: English
• ISBN-10: 1590594223
• ISBN-13: 978-1590594223
• Product Dimensions: 9.1 x 7 x 0.9 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #396,939 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #20 in

  Books > Computers & Internet > Databases > Oracle > DBA

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars Pragmatic, focused, detailed, January 9, 2005

By	Jack D. Herrington "engineer and author" (Silicon Valley, CA) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)

This book is a deep in-depth view of the function of Peoplesoft on an Oracle database. Not only does it cover the fundamentals of how Peoplesoft uses the database features, it also details almost every table in the system on a row by row basis. An in-depth resource which is sure to be invaluable to anyone using this software configuration.

5 of 5 people found the following review helpful:

5.0 out of 5 stars Best PeopleSoft book for Oracle DBA who needs to learn PeopleSoft support, January 22, 2006

By	Benjamin S. Prusinski "real dba" (san diego, ca) - See all my reviews (REAL NAME)

I have been an Oracle DBA for ten years and needed to ramp up very quickly recently for a large client to support their PeopleSoft environment without time to get training on PeopleSoft. This book fits the void left empty as the other PeopleSoft books are geared toward PeopleSoft application developers and not for an Oracle DBA who needs to understand the new ways of working with Oracle databases and PeopleSoft applications. Definitely a gold mine of nuggets for those who need to understand Peoplesoft on Oracle!!

2 of 2 people found the following review helpful:

5.0 out of 5 stars Served as excellent overview for me, August 11, 2007

By	Alex Gorbachev "Alex" (Ottawa, Canada) - See all my reviews

I bought this book just to get familiar with Peoplesoft environment (before the project to install Oracle RAC for Peoplesoft) and cover what I need to know as Oracle DBA. It beats all my expectations - I found lots of DBA relevant details as well as extremely useful overview of architecture and application design with Tuxedo.
After skimming through the book for few hours, I was able to fully understand and talk to Peoplesoft people at client side. In some cases, I knew even more details (or where to get more) than DBA on client site. Showed this book to the client DBA and he was so much thrilled with that - ran and bought it right away.
Well done David! Excellent Job. Thanks!