Tuning Oracle Using An AWR Report

• Tired of just staring at that report? •

Tuning Oracle Using An AWR Report teaches Oracle DBAs how to make Oracle database systems fast using standard Oracle reports and performance data. This seminar will lead you through the entire process turning you into a respected performance analyst. Gone are the futile days working through an entire AWR report top-to-bottom desperately searching for problems. You will learn how to develop solutions that are spot-on and everyone will know it. When users call about a performance problem, you will know what to do, do it fast, and be able to explain the situation with clarity and confidence.

Members Login Become A Member Today

What You Will Learn

  • What is an Oracle Time-Based Analysis
  • What is the OraPub 3-Circle Analysis
  • How problems are exposed using our diagnostic frameworks
  • Why our diagnostic frameworks are a great communication tool
  • How to devise targeted solutions
  • How we use Oracle process CPU consumption in our analysis
  • How Oracle gathers process CPU consumption
  • Where we find Oracle process CPU consumption
  • If Oracle process CPU consumption is reliable
  • The three wait event situations Oracle must handle
  • How Oracle determines wait time by creative observation
  • How an Oracle process knows it is waiting, why and for how long
  • How we use Oracle process wait time in our analysis
  • How we use the Oracle CPU and wait time relationship to optimize performance
  • What is DB Time, elapsed time, DB CPU and wall/run time
  • How parallelism affects elapsed and wall time

Modules

  • The Big Picture: How The Pieces Fit Together
  • Why A Time-Based Analysis Is Awesome
  • Oracle Processes Are CPU Suckers!
  • Oracle Processes Hate To Wait! - Part 1
  • Oracle Processes Hate To Wait! - Part 2
  • Building A Diagnostic/Troubleshooting Framework - Part 1
  • Building A Diagnostic/Troubleshooting Framework - Part 2
  • Finding Multiple Performance Solutions Fast! - Part 1
  • Finding Multiple Performance Solutions Fast! - Part 2
  • How To Create A Great Performance Story - Part 1
  • How To Create A Great Performance Story - Part 2
  • Resources: The Learning Never Stops!

Bonus: Mastering The Material

We created seven, very specific emails to help you apply what you have learned. Think of these as a hands-on, how-to series, leading you through the entire process one step at a time... at your own pace!

It works like this. You will receive the first email after you complete the entire seminar. When you are ready for the next email, you click on a link in the email. Simple! And, if you have questions throughout the email series, you can email Craig for assistance.

Seminar Videos