
High-Performance Oracle
Proven Methods for Achieving Optimum Performance and Availability
- English
- PDF
- Available on iOS & Android
High-Performance Oracle
Proven Methods for Achieving Optimum Performance and Availability
About this book
"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."
-Aki Ratner, President, Precise Software Solutions
Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database.
High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.
The book provides practical solutions for:
* Choosing physical layout for ease of administration and efficient use of space
* Managing indexes, including detecting unused indexes and automating rebuilds
* SQL and system tuning using the powerful new features in Oracle9i Release 2
* Improving SQL performance without modifying code
* Running Oracle Real Application Clusters (RAC) for performance and availability
* Protecting data using Recover Manager (RMAN), and physical and logical standby databases
The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- High-Performance Oracle®: Proven Methods for Achieving Optimum Performance and Availability