Oracle 10G Performance Tuning by Rajeev A Parida

The book Oracle 10g Performance Tuning gives you step-by-step practical advice for removing bottlenecks, minimizing downtime, and increasing overall system performance. You'll also get tips for identifying Oracle's current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistics, and much more. This book is written in a clear and engaging style, and explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork such as:

Designing and developing for performance
Performance Improvement Methods
Understand the key components of a tuning methodology
Tune and manage various components of the Oracle Instance
Use meaningful Oracle initialization parameter settings
Automatic performance Statistics
Memory Configuration and Use
Automatic SQL Tuning
The Query Optimizer
Managing Optimizer Statistics
Using Indexes and Clusters
Using Optimizer Hints
Using explain plan.