Preview unavailable

Course Materials

• Slides

• Lab Guide

SQL Performance Fundamentals

• SQL Performance Fundamentals

Optimizer Fundamentals

• SQL Processing

• Optimizer Concepts

Execution Plans

• About Execution Plans

• Reading Execution Plans

• Generating Execution Plans using SQL*Plus AUTOTRACE

• Generating Execution Plans using EXPLAIN PLAN

Access Paths

• Concepts

• Lab Practices

Join Methods

• Concepts

• Lab Practices

Optimizer Statistics

• About Optimizer Statistics

• When and How Database gathers Optimizer Statistics?

• Configuring Options for Optimizer Statistics gathering

• Gathering Optimizer Statistics

• Lab Practices: Gathering Optimizer Statistics

• Histograms

• Lab Practices: Histograms

• Extended Statistics: Column Group Statistics

• Extended Statistics: Expression Statistics

• Lab Practices: Extended Statistics

• Controlling the use of Optimizer Statistics

• Lab Practices: Controlling the use of Optimizer Statistics

Optimizer Controls

• Using Hints

• Lab Practices: Using Hints

• Cursor Sharing, Adaptive Cursor Sharing

SQL Monitoring

• Monitoring SQLs

SQL Tracing

• Tracing SQLs

SQL Tuning Set

• SQL Tuning Set (STS)

SQL Tuning Advisor

• Concepts

• Lab Practices

SQL Access Advisor

• SQL Access Advisor

SQL Profiles

• SQL Profiles

SQL Plan Management (SPM)

• Concepts

• Lab Practices

Migrating Stored Outlines

• Migrating Stored Outlines to SQL Plan Baselines