The Oracle 11G Performance Tuning By Rajeev A. Parida

The Oracle 11G Performance Tuning By Rajeev A. Parida

---

Book Summary:

The book titled The Oracle 11g Performance Tuning is an aid for the people who are involved in the operation, maintenance, and performance of Oracle database. Implementing tuning solutions using the proven methodology found inside the book gives a step-by-step practical advice for removing bottlenecks, minimizing downtime and increasing overall system performance. It will also helpful in identifying Oracle's current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistic, and much more. Written in a clear engaging style.this book explains how to manage the tuning efforts of various components of an entire system in a methodical fashion, eliminating all guesswork.

Audience of the Book :

The book is also useful for database administrators, application designers and programmers.

 

Key Features:

The main features of the book are as follows:

1. This book explains how to manage the tuning efforts of various components of an entire system in a methodical fashion, eliminating all guesswork.

Table of Contents:

1. Getting Started with Oracle Architecture

2. Designing and Developing for Performance

3. Performance Improvement Methods

4. Configuring a Database for Performance

5. Automatic Performance Statistics

6. Automatic Performance Diagnostics

7. Configuring and Using Memory

8. I/O Configuration and Design

9. Managing Operating System Resources

10. Instance Tuning Using Performance Views

11. The Query Optimizer

12. Using Explain Plan

13. Managing Optimizer Statistics

14. Using Indexes and Clusters

15. Using SQL Plan Management

16. SQL Tuning Overview

17. Automatic SQL Tuning

18. SQL Access Advisor

19. Using Optimizer Hints

20. Using Plan Stability

21. Using Application Tracing Tools

Index