Oracle 10g Performance Tuning Training
Oracle Wait Event Performance Tuning - 21 Hour Online Class or 3 Day Classroom
Designed for DBAs, system administrators, senior developers or anyone responsible for optimizing performance of an Oracle database system. Students receive two fantastic books (including Richmond Shee�s �Oracle Wait Interface: A Practical Guide to Performance Diagnostics and Tuning� and over 200 useful scripts. Covers an introduction to Oracle Database Tuning; Statspack; the Oracle Wait Interface; overview of common I/O-related, Lock-related and Latency-related Wait Events, including causes and recommended actions.
Class Description:
Using the Wait Interface and Active Session History to Tune Oracle DatabasesThrough lecture and hands-on workshops solving real performance problems, you will learn simple yet extremely powerful Oracle Database tuning techniques.This course is based in part on the text, “Oracle Wait Interface: A Practical Guide to Performance Diagnostics and Tuning” by Richmond Shee. Each student will receive:
Audience: Oracle database administrators, computer system administrators, senior application developers, and anyone else who is responsible for achieving optimal performance in Oracle database systems. Prerequisites: Students must possess:
|
If you’re tired of wading though mountains of Statspack reports looking for a needle in a haystack, this class is for you. You will learn:
|
Topic summary
- Introduction to Oracle Database Tuning
- Response Time Tuning Model
- Introduction to Tuning with Wait Events
- Lesson Summary
- Introduction to Statspack
- Lesson Objectives
- Introduction to Statspack
- Statspack Tips
- Executing Statspack
- The Statspack Report
- 2nd Statspack Report
- Lesson Summary
- Workshop
- Introduction to the Oracle Wait Interface
- Lesson Objectives
- OWI Components
- V$EVENT_NAME
- V$SYSTEM_EVENT
- V$SESSION_EVENT
- V$SESSION_WAIT
- Trace Event 10046
- Trace Your Own Session
- Trace File Contents
- Tracing Another Session
- Workshop
- 10g OWI Enhancements
- Active Session History: ASH
- ASH for Session Health Check
- ASH History
- Use ASH to find CPU Hogs
- Use ASH to find Blockers
- V$SESSION_WAIT_HISTORY
- V$SYSTEM_WAIT_CLASS
- V$SESSION_WAIT_CLASS
- V$EVENT_HISTOGRAM
- OWI Limitations
- Lesson Summary
- Workshop
- Common I/O-Related Wait Events
- Lesson Objectives
- log file parallel write
- Common Causes / Action
- db file scattered read
- Parameters
- Recognizing the Problem
- Common Causes / Action
- db file sequential read
- Recognizing the Problem
- Common Causes / Action
- direct path read
- Common Causes / Action
- direct path write
- Common Causes / Action
- control file parallel write
- Lesson Summary
- Workshop
- Common Lock-Related Wait Events
- Lesson Objectives
- What is a Latch?
- latch free
- Shared Pool / Library Cache Latches
- Workshop
- latch free – Cache Buffer Chains
- Causes of Excessive Waits
- Enqueue Wait Event
- Enqueue Parameters
- Wait for TX Enqueue
- Other Enqueue Waits
- buffer busy waits
- 10g buffer busy waits
- buffer busy waits Parameters
- buffer busy waits
- buffer busy waits – Cause / Actions
- Lesson Summary
- Workshop
- Common Latency-Related Wait Events
- Lesson Objectives
- log file switch *
- log file switch – Fixes
- log file parallel write
- log file sync
- log file sync – Causes / Fixes
- log buffer space
- log file switch (archiving needed)
- write complete waits
- Lesson Summary
- Workshop


