High Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability
- 13h 15m
- Geoff Ingram
- John Wiley & Sons (US)
- 2002
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
About the Author
Geoff Ingram has spent his entire career in the IT industry, including several years working as a product developer at Oracle Corporation. Since leaving Oracle, he has operated as a freelance consultant for blue chip companies in the banking and telecommunication sectors. He focuses on delivering Oracle systems that meet end-user performance and availability requirements, and has developed a free software application for fine-tuning Oracle applications.
In this Book
-
High-Performance Oracle—Proven Methods for Achieving Optimum Performance and Availability
-
Introduction
-
Installing Oracle
-
Database Creation
-
Configuring OracleNetworking
-
Environment Standards and Tools
-
Securing Your Database
-
Designing Supportable Applications
-
Choosing Third-Party Software
-
End-to-End Performance Management
-
Fundamentals of SQL Tuning
-
Collecting and Using Optimizer Statistics
-
Partitioning
-
Managing Indexes
-
Managing Space Growth
-
Stress Testing and Benchmarks
-
Server Consolidation and Resource Management
-
Selecting and Using Performance Management Tools
-
Fundamentals of Oracle Recovery
-
Backup and Recovery Using Recovery Manager (RMAN)
-
Backup and Restore Using Export and Import
-
VERITAS High Availability (HA) for Oracle
-
Oracle Replication
-
Oracle Real Application Clusters
-
Protecting Data Using Standby Databases
-
Guidelines for Health Checks and Monitoring
-
Auditing Techniques
-
Migration and Upgrade
-
Working Effectively with Oracle Support
-
Troubleshooting Oracle DBMS Problems
