Contents

Title and Copyright Information

Preface

What's New in Oracle Performance?

Part I Performance Tuning

1 Performance Tuning Overview

Part II Performance Planning

2 Designing and Developing for Performance

3 Performance Improvement Methods

Part III Optimizing Instance Performance

4 Configuring a Database for Performance

5 Automatic Performance Statistics

6 Automatic Performance Diagnostics

7 Memory Configuration and Use

8 I/O Configuration and Design

9 Understanding Operating System Resources

10 Instance Tuning Using Performance Views

Part IV Optimizing SQL Statements

11 SQL Tuning Overview

12 Automatic SQL Tuning

13 The Query Optimizer

14 Managing Optimizer Statistics

15 Using Indexes and Clusters

16 Using Optimizer Hints

17 SQL Access Advisor

18 Using Plan Stability

19 Using EXPLAIN PLAN

20 Using Application Tracing Tools

Part V Real Application Testing

21 Database Replay

22 SQL Performance Analyzer

Glossary

Index