Oracle Wait Event Performance Tuning
- 21 Hour Online Class or 3 Day Classroom Workshop
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.
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”!
