Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database 2 Day + Performance Tuning Guide
- Part I Getting Started
-
Part II Proactive Database Tuning
-
3
Automatic Database Performance Monitoring
- 3.1 Overview of Automatic Database Diagnostic Monitor
- 3.2 Configuring Automatic Database Diagnostic Monitor
- 3.3 Reviewing the Automatic Database Diagnostic Monitor Analysis
- 3.4 Interpretation of Automatic Database Diagnostic Monitor Findings
- 3.5 Implementing Automatic Database Diagnostic Monitor Recommendations
- 3.6 Viewing Snapshot Statistics
- 4 Monitoring Real-Time Database Performance
- 5 Monitoring Real-Time Database Operations
- 6 Monitoring Performance Alerts
-
3
Automatic Database Performance Monitoring
-
Part III Reactive Database Tuning
- 7 Manual Database Performance Monitoring
- 8 Resolving Transient Performance Problems
- 9 Resolving Performance Degradation Over Time
-
10
Using Automatic Workload Repository Warehouse for Generating Performance Reports
- 10.1 Setting Up the AWR Warehouse
- 10.2 Working with Source Databases
- 10.3 Uploading Snapshots to the AWR Warehouse
- 10.4 Using Performance Pages with the AWR Warehouse
- 10.5 Monitoring and Researching Incidents and Errors
- 10.6 AWR Warehouse Best Practices
-
Part IV SQL Tuning
-
11
Identifying High-Load SQL Statements
- 11.1 Identification of High-Load SQL Statements Using ADDM Findings
- 11.2 Identifying High-Load SQL Statements Using Top SQL
-
12
Tuning SQL Statements
- 12.1 Tuning SQL Statements Using SQL Tuning Advisor
-
12.2
Managing SQL Tuning Sets
-
12.2.1
Creating a SQL Tuning Set
- 12.2.1.1 Creating a SQL Tuning Set: Options
-
12.2.1.2
Creating a SQL Tuning Set: Load Methods
- 12.2.1.2.1 Loading Active SQL Statements Incrementally from the Cursor Cache
- 12.2.1.2.2 Loading SQL Statements from the Cursor Cache
- 12.2.1.2.3 Loading SQL Statements from AWR Snapshots
- 12.2.1.2.4 Loading SQL Statements from AWR Baselines
- 12.2.1.2.5 Loading SQL Statements from a User-Defined Workload
- 12.2.1.3 Creating a SQL Tuning Set: Filter Options
- 12.2.1.4 Creating a SQL Tuning Set: Schedule
- 12.2.2 Dropping a SQL Tuning Set
- 12.2.3 Transporting SQL Tuning Sets
-
12.2.1
Creating a SQL Tuning Set
- 12.3 Managing SQL Profiles
- 12.4 Managing SQL Plan Baselines
-
13
Optimizing Data Access Paths
- 13.1 Running SQL Access Advisor
- 13.2 Reviewing the SQL Access Advisor Recommendations
- 13.3 Implementing the SQL Access Advisor Recommendations
-
11
Identifying High-Load SQL Statements
- Index