Oracle Training : Oracle9i Database Performance Tuning

Oracle9i Database Performance Tuning

Oracle Training Overview

This course presents techniques for finding performance or configuration problems within the Oracle database and solving those problems. Manual techniques as well as those employing the specialty Packs within Oracle Enterprise Manager are considered. Workshop exercises allow participants the opportunity to examine the internal operation of an Oracle instance, isolate problems, test possible solutions and implement effective remedies.

This course was formerly called �Oracle9i Database Tuning & Troubleshooting�.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL

The course Introduction To Oracle9i: SQL
The course Introduction To Oracle9i: PL/SQL Language
The course Introduction To Oracle9i: Advanced SQL
The course Oracle9i Database Administration - DBA I
The course Oracle9i Database Backup & Recovery - DBA II

Oracle Training Audience

Oracle database administrators.

Oracle Training Objectives

Avoid locking and contention problems
Tune and troubleshoot SGA buffers
Tune and troubleshoot the shared pool
Tune and troubleshoot data file configuration problems
Use utlBstat and utlEstat

Suggested Next Courses

The course Oracle 9i New & Advanced Features For DBAs

Oracle Training Course duration

5 Days

Oracle Training Course outline

Configuring & Tuning Automatic Undo Space Management

About Undo Space
Configuring Automatic Undo Space Management
Tuning Automatic Undo Space Management

Tuning Manual Rollback Segments

Using The Sql Tuning Utilities Tkprof & Autotrace

About The Sql Execution Environment
About Autotrace

Using The Database Tuning Utilities

About Collecting Statistics
About The Utlbstat & Utlestat Utilities
About The Statspack Utility
The Oem Performance Manager

Memory Tuning (Buffer Cache)

About The Memory Structures
About The Buffer Cache
Monitoring The Buffer Cache
Tuning The Buffer Cache
Specialty Tuning Techniques

Memory Tuning (Shared Pool Library Cache)

Monitoring The Library Cache
Tuning The Library Cache
Monitoring Adjustments To The Sga
V$Sga_Current_Resize_Ops
V$Sga_Dynamic_Components
V$Sga_Resize_Ops
V$Sga_Dynamic_Free_Memory

Additional Memory Tuning

Monitoring & Tuning The Dictionary Cache
Utilizing The Large Pool
Monitoring & Tuning The Pga/Uga
V$Sesstat, V$Statname
V$Process
V$Sysstat
V$Sql_Workarea_Histogram
V$Sql_Workarea_Active
V$Pgastat
V$Pga_Target_Advice
V$Pga_Target_Advice_Histogram
Monitoring & Tuning The Redo Log Buffer

File I/O Tuning

Monitoring Database I/O
Tuning Database I/O

Monitoring Latches, Locks & Contention

V$Lock
V$Lock Columns
V$Locked_Object
V$Session
V$Session_Wait
Dba_Blockers & Dba_Waiters
Dba_Dml_Locks & Dba_Ddl_Locks
Dml_Locks

Troubleshooting Using The Dbms_Repair() Package

Using The Dbms_Repair() Procedures
Admin_Tables()
Check_Object()
Fix_Corrupt_Blocks()
Skip_Corrupt_Blocks()
Dump_Orphan_Keys()
Rebuild_Freelists()
Segment_Fix_Status()

Resumable Space Allocation

Managing Resumable Space Allocation
Implementing Special Features

Utilizing Logminer

Using The Logminer Package
Dbms_Logmnr_D.Build()
Dbms_Logmnr()
Dbms_Logmnr.Add_Logfile()
Dbms_Logmnr.Start_Logmnr()
Dbms_Logmnr.End_Logmnr()
Using The Results Of Logminer Analysis
Using The Logminer Viewer

Database Resource Manager

Plans, Groups And Directives
Cpu
Procedures And Operations
A Simple Resource Plan
Create_Simple_Plan Procedure
System_Plan
Administering Complex Resource Plans