Oracle9I Database Performance Tuning Course

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 is also called “Oracle9i Database Tuning & Troubleshooting”.

This course is designed for Oracle database administrators.

Upon completion of this course, the participant will be able to:
>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

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

Oracle9i SQL (RT 262)
Oracle9i Advanced SQL (RT 258)
Oracle9i PL/SQL Language (RT 275)
Oracle9i Database Administration - DBA I (RT 264)
Oracle9i Database Backup & Recovery - DBA II (RT 263)