PeopleSoft for the Oracle DBA

Häftad, Engelska, 2004

AvDavid Kurtz

619 kr

Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.

Finns i fler format (1)

Häftad

929 kr

Skickas inom 10-15 vardagar

This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft system.

Produktinformation

Utgivningsdatum2004-11-24
Mått178 x 235 x 25 mm
Vikt794 g
FormatHäftad
SpråkEngelska
Antal sidor456
Upplaga4001
FörlagAPress
ISBN9781590594223

Tillhör följande kategorier

Databaser inom Data och it
Programvaruutveckling inom Data och it

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

Architecture Overview.-BEA Tuxedo, PeopleSoft’s Application Server.- PeopleSoft Database Structure: A Tale of Two Data Dictionaries.- Database Connectivity.- Keys & Indexing.- PeopleSoft DDL.- Tablespaces.- Database Privileges of PeopleSoft Schemas.- Performance Metrics.- PeopleSoft Performance Monitoring Utilities.- SQL Optimization Techniques in PeopleSoft.- Tuxedo Configuration and Tuning.- Tuxedo Utilities.- Tuxedo Webserver.