"Geoff Ingram has met the challenge of presenting the complexprocess of managing Oracle performance. This book can support everytechnical person looking to resolve Oracle8i and Oracle9iperformance issues."
-Aki Ratner, President, Precise Software Solutions
Ensuring high-performance and continuous availability of Oraclesoftware is a key focus of database managers. At least a dozenbooks address the subject of "performance tuning"-- that is, how tofine-tune the Oracle database for its greatest processingefficiency. Geoff Ingram argues that this approach simply isn'tenough. He believes that performance needs to be addressed rightfrom the design stage, and it needs to cover the entire system--notjust the database.
High-Performance Oracle is a hands-on book, loaded with tips andtechniques for ensuring that the entire Oracle database system runsefficiently and doesn't break down. Written for Oracle developersand DBAs, and covering both Oracle8i and Oracle9i, the book goesbeyond traditional performance-tuning books and covers the keytechniques for ensuring 24/7 performance and availability of thecomplete Oracle system.
The book provides practical solutions for:
Choosing physical layout for ease of administration and efficientuse of space
Managing indexes, including detecting unused indexes andautomating rebuilds
SQL and system tuning using the powerful new features in Oracle9iRelease 2
Improving SQL performance without modifying code
Running Oracle Real Application Clusters (RAC) for performanceand availability
Protecting data using Recover Manager (RMAN), and physical andlogical standby databases
The companion Web site provides the complete source code forexamples in the book, updates on techniques, and additionaldocumentation for optimizing your Oracle system.