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 Pricing:​

• $449 USD for Free members
• $359 USD for Essential and Advantage members (ask for your coupon code)
• FREE for Prime members (just ask to be registered)

Class Outline:

Session 1. AWR Report Analysis Setup In 30 Minutes Or Less

• Rapid Fire AWR Analysis - Part 1
• Using An AWR Report As Designed
• Performing A 360 Degree Analysis (3 Circle Analysis)

Session 2. Oracle Time Deep Dive

• Performing an Oracle Time-Based Analysis (OTBA)
• Oracle Time Component Detailed Breakdown
• How To Determine The Operating System Bottleneck Using Only An AWR Report

Session 3. Developing Solutions And Story

• Specifying And Identifying The Most Important PL/SQL
• Rapid Fire Analysis - Part 2
• Integrating All Analysis Pieces

Details: 

Class Hours: There are six hours of live, interactive webinar training divided into three 2-hour sessions.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations and lots of Q&A time. Craig types a lot during class. This "session log" is available after each session. If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Your AWR Reports: It is important to relate Craig's teaching and demonstrations with your production system's AWR reports. Craig encourages everyone to send him their AWR reports along with their "Rapid Fire Analysis." Craig prefers to use student AWR reports during class.

Class requirements:

You will need...

• The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone. Craig is the only one that speaks, but all students are able to type their questions, answers and comments... It's very lively! Oracle software is not required during the live training.
• The ability to connect and query AWR or Statspack data from an Oracle system. You can connect to Oracle using the tool of your choice, such as SQL*Plus or SQL Developer. You will also need to access the v$ and DBA views and the ability to generate either an AWR or Statspack report. We do not use OEM. If you can tune Oracle from the command line, you can tune Oracle using any respectable GUI tool. Also, Craig only uses SQL*Plus, so you can type exactly what he types.