Course Introduction
Workshop 1: Enhancing the Performance of aSQL Query Statement
Introduction to SQL Tuning
Quick Solution Strategy
Workshop 2: Reviewing the Execution Steps of the SQL Statement
Practice 2-1: Using SQL Developer
Using Application Tracing Tools
trcsess Utility
Workshop 3: Learn to Tune Sort Operation Using an Index in the ORDER BY Clauses
Practice 3-1: Tracing Applications (Part 01)
Practice 3-1: Tracing Applications (Part 02)
Optimizer Fundamentals
Query Estimator: Selectivity and Cardinality
Plan Generator
Workshop 4: Identifying and Tuning a Poorly Written SQL Statement
Practice 4-1: Understanding Optimizer Decisions(Optional)
Generating and Displaying Execution Plans
AUTOTRACE
Automatic Workload Repository
Workshop 5: Effects of Changing the Column
Order in a Composite Index
Practice 5-1: Extracting an Execution Plan by Using SQL Developer
Practice 5-2: Extracting Execution Plans
Interpreting Execution Plans and Enhancements
Workshop-6: Using Information in the 10053
File to Tune a SQL Statement
Practice 6-1: Using Dynamic Plans
Optimizer: Table and Index Access Paths
Indexes: Overview
Bitmap Indexes
Common Observations
Workshop 7: Understanding the Optimizer’s Decision
Practice 7-1: Using Different Access Paths (Part01)
Practice 7-1: Using Different Access Paths (Part02)
Practice 7-1: Using Different Access Paths (Part03)
Practice 7-1: Using Different Access Paths (Part04)
Optimizer: Join Operators
Workshop 8: Tuning Strategy
Practice 8: Using Join Paths
Other Optimizer Operators
Workshop 9: Using SQL Plan Baseline to
Manage a Better Execution Plan
Practice 9-1: Using the Result Cache
Practice 9-2: Using Other Access Paths (Optional)
Introduction to Optimizer Statistics Concepts
Column Statistics: Histograms
Session-Specific Statistics for Global Temporary Tables
Practice 10-1: Index Clustering Factor
Practice 10-2: Creating Expression Statistics
Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 01)
Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 02)
Practice 10-4: Using System Statistics(Optional)
Using Bind Variables
Cursor Sharing Enhancements
Practice 11-1: Using Adaptive Cursor Sharing
Practice 11-2: Using CURSOR_SHARING(Optional)
SQL Plan Management
Configuring SQL Plan Management
Possible SQL Plan Manageability Scenarios
Practice 12-1: Using SQL Plan Management SPM (Part 01)
Practice 12-1: Using SQL Plan Management SPM (Part 02)
Workshops