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
- ADDM Spotlight
-
8
Monitoring Databases with Performance Hub
- About Performance Hub
- Performance Hub Features
- Using Performance Hub to Analyze Database Performance
-
Part III Tuning Database Memory
- 9 Database Memory Allocation
-
10
Tuning the System Global Area
- Using Unified Memory
- Using Automatic Shared Memory Management
- Unified Program Global Area
- 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
-
11
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
-
12
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
-
13
Tuning the Result Cache
- About the Result Cache
- Configuring the Result Cache
- Specifying Queries for Result Caching
- Monitoring the Result Cache
-
14
Tuning the Process Global Area
- About the Process 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
-
15
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
-
16
Managing Operating System Resources
- Understanding Operating System Performance Issues
- Resolving Operating System Issues
- Understanding CPU
- Resolving CPU Issues
- 17 Working With Automatic Materialized Views
-
15
I/O Configuration and Design
- Glossary
- Index