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.

Online Class Schedule

Request a Class

 		 

Request More Info


 

Topic Summary | Print Version

Class Description:

Using the Wait Interface and Active Session History to Tune Oracle Databases

Through 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:

  • One copy of the Richmond Shee text, with the associated 154 tuning scripts
  • One copy of the SkillBuilders course book, “Oracle Database Performance Tuning”
  • An additional 50 scripts written or enhanced by SkillBuilders

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:

  • An understanding of Oracle Architecture (for example, what is the SGA, shared pool, buffer cache and PGA?)
  • Solid experience with SQL
  • Skills required to “get around” the operating system used in the classroom

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:

  • How to, in a minute or less, uncover a general performance problem with a database.
  • What to look for in a Statspack report and, just as important, what can be ignored and why.
  • The Oracle wait events – the concepts, the meaning of the major events and how to solve the problems they reveal.
  • How to use the Active Session History (ASH) quickly and easily reveal database load, top consumers and hard-to-find wait-related problems.
  • A simple yet powerful, effective and repeatable tuning methodology that you can apply to any Oracle database.
  • Solve Oracle Database performance problems without dedicating the next year of your life to 12 hour days and “the mysterious art of Oracle Database tuning”!

Topic summary

 

To Top | Topic Summary