Oracle 10g DBA Performance Tuning — A 4 day course

contact usEnquire about this course
Retired Course; no longer available


Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action.


By the end of the course, delegates will be able to:

The delegate will practice:

Suitable For

This course is suitable for database administrators, application developers and technical support staff who are required to monitor and tune an Oracle Database 10g.


Delegates should have a working knowledge of SQL*Plus, PL/SQL and Oracle Database Administration.

This can be obtained by attendance on the Oracle SQL and Oracle Database 10g DBA Part I courses.

Some operating system experience is essential.


This course has been retired and is no longer available.


Introduction to Oracle Performance Tuning

Diagnosing Problems

Tools For Evaluating SQL Statements

The Optimizer


Advanced Indexes

Types of Table joins

Metrics, Alerts and Baselines


Automatic Workload Repository

Reactive Tuning

Tuning the Shared Pool

Tune The Buffer Cache

Automatic Memory Management

Tune PGA and Temporary Space

Checkpoint and Redo Tuning

Tune I/O

Use Oracle Blocks Efficiently

Materialized Views

Parallel Execution

Tracing Services