PeopleSoft for the Oracle DBA [NOOK Book]

Be the first to write a review

Overview

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

See more details below
PeopleSoft for the Oracle DBA

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.49
BN.com price
(Save 42%)$43.99 List Price

More About This Book

Overview

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.



Read More Show Less

Product Details

  • ISBN-13: 9781430204084
  • Publisher: Apress
  • Publication date: 11/23/2004
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 456
  • File size: 7 MB

Meet 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).

Read More Show Less

Table of Contents

Ch. 1 An overview 1
Ch. 2 BEA Tuxedo : PeopleSoft's application server technology 15
Ch. 3 Database connectivity 31
Ch. 4 PeopleSoft database structure : a tale of two data dictionaries 55
Ch. 5 Keys and indexing 87
Ch. 6 PeopleSoft DDL 115
Ch. 7 Tablespaces 149
Ch. 8 Locking, transactions, and concurrency 163
Ch. 9 Performance metrics 171
Ch. 10 PeopleTools performance utilities 229
Ch. 11 SQL optimization techniques in PeopleSoft 263
Ch. 12 Configuring the application server 315
Ch. 13 Tuning the application server 359
Ch. 14 The process scheduler 387
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)