Oracle SQL Tuning (2 days)

Audience: An ideal course for anyone who wants to learn about the various tuning methods available for SQL and to gain a better understanding of how the optimizer works.
 
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Brief Database Architecture Overview and Importance of Bind Variables

Introducing the Optimizer

Displaying Execution plans

Optimizer Operations - Optimizer Access Paths

Optimizer Operations - Joins and Subqueries

Other Common Optimizer Operations

Using TKPROF and TRCSESS

Understand Basic Tuning Techniques

Optimizer Hints and Result Cache