Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Performance Tuning Guide
-
Part I Database Performance Fundamentals
- 1 Performance Tuning Overview
-
2
Designing and Developing for Performance
- Oracle Methodology
- Understanding Investment Options
- Understanding Scalability
- System Architecture
- Application Design Principles
- Workload Testing, Modeling, and Implementation
- Deploying New Applications
- 3 Performance Improvement Methods
- 4 Configuring a Database for Performance
-
Part II Diagnosing and Tuning Database Performance
- 5 Measuring Database Performance
-
6
Gathering Database Statistics
- About Gathering Database Statistics
-
Managing the Automatic Workload Repository
- Enabling the Automatic Workload Repository
- Managing Snapshots
- Managing Baselines
- Managing Baseline Templates
- Transporting Automatic Workload Repository Data to Another System
- Using Automatic Workload Repository Views
- Managing Automatic Workload Repository in a Multitenant Environment
- Managing Automatic Workload Repository in Active Data Guard Standby Databases
-
Generating Automatic Workload Repository Reports
- User Interface for Generating an AWR Report
-
Generating an AWR Report Using the Command-Line Interface
- Generating an AWR Report for the Local Database
- Generating an AWR Report for a Specific Database
- Generating an AWR Report for the Local Database in Oracle RAC
- Generating an AWR Report for a Specific Database in Oracle RAC
- Generating an AWR Report for a SQL Statement on the Local Database
- Generating an AWR Report for a SQL Statement on a Specific Database
- Generating Performance Hub Active Report
-
7
Automatic Performance Diagnostics
- Overview of the Automatic Database Diagnostic Monitor
- Setting Up ADDM
- Diagnosing Database Performance Problems with ADDM
- ADDM Views
-
8
Comparing Database Performance Over Time
- About Automatic Workload Repository Compare Periods Reports
- Generating Automatic Workload Repository Compare Periods Reports
-
Interpreting Automatic Workload Repository Compare Periods Reports
- Summary of the AWR Compare Periods Report
-
Details of the AWR Compare Periods Report
- Time Model Statistics
- Operating System Statistics
- Wait Events
- Service Statistics
- SQL Statistics
- Instance Activity Statistics
- I/O Statistics
- Advisory Statistics
- Wait Statistics
- Undo Segment Summary
- Latch Statistics
- Segment Statistics
- In-Memory Segment Statistics
- Dictionary Cache Statistics
- Library Cache Statistics
- Memory Statistics
- Advanced Queuing Statistics
- Supplemental Information in the AWR Compare Periods Report
- 9 Analyzing Sampled Data
-
10
Instance Tuning Using Performance Views
- Instance Tuning Steps
- Interpreting Oracle Database Statistics
-
Wait Events Statistics
- Changes to Wait Event Statistics from Past Releases
- buffer busy waits
- db file scattered read
- db file sequential read
- direct path read and direct path read temp
- direct path write and direct path write temp
- enqueue (enq:) waits
- events in wait class other
- free buffer waits
- Idle Wait Events
- latch events
- log file parallel write
- library cache pin
- library cache lock
- log buffer space
- log file switch
- log file sync
- rdbms ipc reply
- SQL*Net Events
-
Tuning Instance Recovery Performance: Fast-Start Fault Recovery
- About Instance Recovery
- Configuring the Duration of Cache Recovery: FAST_START_MTTR_TARGET
- Tuning FAST_START_MTTR_TARGET and Using MTTR Advisor
-
Part III Tuning Database Memory
- 11 Database Memory Allocation
-
12
Tuning the System Global Area
- Using Automatic Shared Memory Management
- Sizing the SGA Components Manually
- Monitoring Shared Memory Management
- Improving Query Performance with the In-Memory Column Store
- Enabling High Performance Data Streaming with the Memoptimized Rowstore
-
13
Tuning the Database Buffer Cache
- About the Database Buffer Cache
- Configuring the Database Buffer Cache
- Configuring Multiple Buffer Pools
- Configuring the Redo Log Buffer
- Configuring the Database Caching Mode
-
14
Tuning the Shared Pool and the Large Pool
- About the Shared Pool
- Using the Shared Pool
-
Configuring the Shared Pool
- Sizing the Shared Pool
- Deallocating Cursors
- Caching Session Cursors
- Sharing Cursors
- Keeping Large Objects to Prevent Aging
- Configuring the Reserved Pool
- Configuring the Large Pool
-
15
Tuning the Result Cache
- About the Result Cache
- Configuring the Result Cache
- Specifying Queries for Result Caching
- Monitoring the Result Cache
-
16
Tuning the Program Global Area
- About the Program Global Area
- Sizing the Program Global Area Using Automatic Memory Management
- Sizing the Program Global Area by Specifying an Absolute Limit
-
Part IV Managing System Resources
-
17
I/O Configuration and Design
- About I/O
- I/O Configuration
- I/O Calibration Inside the Database
- I/O Calibration with the Oracle Orion Calibration Tool
-
18
Managing Operating System Resources
- Understanding Operating System Performance Issues
- Resolving Operating System Issues
- Understanding CPU
- Resolving CPU Issues
-
17
I/O Configuration and Design
- Glossary
- Index