This course will give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques.  The student learns the necessary knowledge & stills to effectively tune SQL in the Oracle Database.

Duration: 2 Days

Overview of Database architecture
Listing the SQL Statement Processing Steps
Identifying Means to Minimize Parsing
Describing the Causes of Performance Problems
Identifying Performance Problems
Using a Tuning Methodology
Describe the functions of the Oracle optimizer
Identify the factors that the optimizer considers when it selects an execution plan
Set the optimizer approach at the instance & session level
Use dynamic sampling
Execution plans
Types of Joins
Using the EXPLAIN PLAN Command
Interpreting EXPLAIN Output
Interpreting AUTOTRACE Statistics
Using the DBMS_STATS Package
Identifying Table, Column, & Index Statistics
Statspack
Invoking the SQL Trace Facility
Setting Up Appropriate Initialization Parameters
Formatting Trace Files with TKPROF
Interpreting the Output of the TKPROF Command
ADDM
Statspack
SQL Tuning Advisor
Identifying Row Access Methods
Creating B-Tree Indexes
Understanding B-Tree Index Access & Index Merging
Using Hints

Before attending this course, students must have an understanding of Oracle8i or Oracle9i Database Administration, experience in Oracle tuning, backup and recovery, & networking, & SQL & PL/SQL programming experience is also required.

This course is designed for Oracle8i or Oracle9i Database Administrators who want a comprehensive overview of the New Features of Oracle10g.