Back to Search Results

Training Course Summary:

Delegates:

This course is designed for SQL*Plus Programmers, Application Designers/Developers and Technical Support professionals who are required to monitor and tune the performance of an Oracle8i or 9i application.

Objectives:

By the end of the course, the delegate will be able to:
Tune Database Applications for Optimal Performance
Structure Tables and Indexes for Performance
Defrag Database Objects
Identify and Resolve Row Chaining and Migration
Rebuild Indexes
Identify Unused Indexes
Manage Statistics
Structure SQL Statements for Performance
Use the SQL Optimizers
Examine the Execution Plan of an SQL Statement using EXPLAIN PLAN
Examine the Efficiency of SQL Statements using SQL Trace and Autotrace
Use Hints to influence Execution Plan
Use Parallel DML

Topics Covered:

Tuning Methodology
Diagnostic Tools
Understanding the SGA and the UGA and the large pool
Tuning Database Applications
Sizing Extents
Structuring Tables and Indexes for Performance
Monitoring and Tuning Indexes
Structuring SQL Statements for Performance
Tuning SQL Statements
SQL Optimizer
8i and 9i Optimizer and Query improvements
SQL Trace
The tkprof command
Using explain plan
The DBMS_APPLICATION_INFO package
Controlling plan stability with stored outlines
Managing statistics with DBMS_STATS
Optimizing Top Queries
Monitoring Long Running operations
Enforce Data Integrity
Tune PL/SQL Code

Requirements:

A working knowledge of SQL*Plus and PL/SQL is required. This can be obtained by attendance on the Pre-Requisite courses.

Pre-Requisites Courses:

SQL*Plus

PL/SQL


Follow-On Courses:

Reports

Forms 6i - Part I

DBA Part I - Architecture & Administration