Tuning Oracle Using An AWR Report

Laser-focused quick analysis setup for ANY AWR Report

"I want to thank Craig for teaching this AWR class... Man, I got on a P-1 call yesterday. Users have been complaining about latency for months on this database, and we have just been fumbling our way through it. I quickly brought up my OTBA template, ran an AWR, figured the big pile of time was on CPU, looked at the SQL ordered by CPU Time and found the culprits. I felt so empowered knowing full well we got the bad guy in the first place and took the focus away from the database and back on the app developers. So, thank you!" 

Jide Odulana, Senior Oracle DBA

Minneapolis, Minnesota, USA

Why should I attend this class?

  • You are doing it wrong

    If you are starting from the top and working your way down looking for something unusual, this is the WRONG way to go. We show you the right way to use the report.

  • Find the "true" top SQL

    There is a way to clearly define what the "top" SQL is so you don't have to guess. We show you how.

  • Perform a spot-on analysis

    You will learn how to do a laser-focused quick analysis setup for ANY AWR Report in the very first session. You will be able to do this setup in 30 minutes or less!

  • Get 100% clarity & confidence

    We guarantee it! We don't want you struggling to analyze an AWR Report. We give you the tools to be clear and confident.

You will be taught how to:​

  • Do an AWR Report analysis setup in 30 minutes or less
  • Know when an AWR analysis is or is not the best approach
  • Integrate your operating system analysis into the broader analysis
  • Derive multiple targeted solutions
  • Demonstrate Oracle's time model CPU time & wait time collection strategies
  • Use OraPub's 3-Circle analysis
  • Check that Oracle's time model is reporting as expected
  • Recognize and avoid AWR analysis pitfalls
  • Find the true "top" SQL
  • Perform quick, rapid-fire AWR analysis using precision simplification
  • Reach deeper understanding and communicate better using wait time data analysis
  • Pick and rank the most impactful solutions
  • Explain your analysis process and solutions to anyone
  • Oracle version-proof your analysis

Class Outline:

Welcome OraPub Members!

Enter the member portal and be ready to be transformed in your Oracle DBA work.