Skip to main content

Introducing new learning courses and educational videos from Apress. Start watching

  • Book
  • © 2012

PeopleSoft for the Oracle DBA

Apress

Authors:

  • Soft for the Oracle DBA provides the help database administrators need to manage and troubleshoot People.

  • Soft as deployed atop an Oracle Database.

Buying options

eBook
USD 49.99
Price excludes VAT (USA)
  • ISBN: 978-1-4302-3708-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD 64.99
Price excludes VAT (USA)

This is a preview of subscription content, access via your institution.

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xxiv
  2. An Overview

    • David Kurtz
    Pages 1-16
  3. Database Connectivity

    • David Kurtz
    Pages 37-61
  4. Keys and Indexing

    • David Kurtz
    Pages 101-141
  5. PeopleSoft DDL

    • David Kurtz
    Pages 143-190
  6. Tablespaces

    • David Kurtz
    Pages 191-200
  7. Locking, Transactions, and Concurrency

    • David Kurtz
    Pages 201-211
  8. Performance Metrics

    • David Kurtz
    Pages 213-267
  9. PeopleTools Performance Utilities

    • David Kurtz
    Pages 269-330
  10. SQL Optimization Techniques in PeopleSoft

    • David Kurtz
    Pages 331-405
  11. Configuring the Application Server

    • David Kurtz
    Pages 407-451
  12. Tuning the Application Server

    • David Kurtz
    Pages 453-487
  13. The Process Scheduler

    • David Kurtz
    Pages 489-512
  14. Back Matter

    Pages 513-523

About this book

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

About the author

David Kurtz began working with version 5.1 of the Oracle database in 1989 in a small software house as an Oracle developer/database administrator working on assurance and insurance software. In 1996, he joined PeopleSoft U.K., 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, he started by working out the relationship between the application and database for himself. This led to fixing performance problems in PeopleSoft systems. Soon enough, David was spending all of his time on performance-related consultancy. David left PeopleSoft in 2000 to go into business for himself as Go-Faster Consultancy Ltd. (http://Go-Faster.co.uk). There, he provides performance and technical consultancy, mostly to PeopleSoft users, mostly on Oracle. Since then, Kurtz has learned to apply principles of response-based performance, not just to the database, but holistically to the entire application stack. David has been a member of the U.K. Oracle User Group since 1994. He chaired the UNIX SIG between 2000 and 2006, and serves on the board of directors. He presents regularly at PeopleSoft and Oracle conferences and meetings. David is a member of the OakTable Network (OakTable.net) and is also an Oracle ACE Director. David started the lively PeopleSoft DBA Forum on Yahoo!(http://groups.yahoo.com/group/psftdba) following a roundtable discussion at a PeopleSoft conference in 2002, and it continues to be a valuable resource. He writes two blogs: PeopleSoft (http://blog.psftdba.com) and exclusively Oracle database (http://blog.go-faster.co.uk).

Bibliographic Information

Buying options

eBook
USD 49.99
Price excludes VAT (USA)
  • ISBN: 978-1-4302-3708-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD 64.99
Price excludes VAT (USA)