Oracle Methodology

Understanding Investment Options

Understanding Scalability

System Architecture

Application Design Principles

Workload Testing, Modeling, and Implementation

Deploying New Applications

The Oracle Performance Improvement Method

Emergency Performance Methods

Performance Considerations for Initial Instance Configuration

Creating and Maintaining Tables for Good Performance

Performance Considerations for Shared Servers

Overview of Data Gathering

Automatic Workload Repository

Introduction to Database Diagnostic Monitoring

Automatic Database Diagnostic Monitor

Understanding Memory Allocation Issues

Configuring and Using the Buffer Cache

Configuring and Using the Shared Pool and Large Pool

Configuring and Using the Redo Log Buffer

PGA Memory Management

Understanding I/O

Basic I/O Configuration

Understanding Operating System Performance Issues

Solving Operating System Problems

Finding System CPU Utilization

Instance Tuning Steps

Interpreting Oracle Statistics

Wait Events Statistics

Idle Wait Events

Understanding Connection Models

Detecting Network Problems

Solving Network Problems

Introduction to SQL Tuning

Goals for Tuning

Identifying High-Load SQL

Automatic SQL Tuning Features

Developing Efficient SQL Statements

Automatic SQL Tuning Overview

SQL Tuning Advisor

Managing SQL Profiles with APIs

SQL Tuning Sets

SQL Tuning Information Views

Optimizer Operations

Choosing an Optimizer Goal

Enabling and Controlling Query Optimizer Features

Understanding the Query Optimizer

Understanding Access Paths for the Query Optimizer

Understanding Joins

Understanding Statistics

Automatic Statistics Gathering

Manual Statistics Gathering

System Statistics

Managing Statistics

Viewing Statistics

Understanding Index Performance

Using Function-based Indexes for Performance

Using Partitioned Indexes for Performance

Using Index-Organized Tables for Performance

Using Bitmap Indexes for Performance

Using Bitmap Join Indexes for Performance

Using Domain Indexes for Performance

Using Clusters for Performance

Using Hash Clusters for Performance

Understanding Optimizer Hints

Using Optimizer Hints

Using Plan Stability to Preserve Execution Plans

Using Plan Stability with Query Optimizer Upgrades

Understanding EXPLAIN PLAN

The PLAN_TABLE Output Table

Displaying PLAN_TABLE Output

Reading EXPLAIN PLAN Output

Viewing Parallel Execution with EXPLAIN PLAN

Viewing Bitmap Indexes with EXPLAIN PLAN

Viewing Partitioned Objects with EXPLAIN PLAN

End to End Application Tracing

Using the traces Utility

Understanding SQL Trace and TKPROF

Using the SQL Trace Facility and TKPROF

Avoiding Pitfalls in TKPROF Interpretation

Sample TKPROF Output