You will be able to:

• Exploit sample-based analysis, going beyond counts and percentages
• Infer SQL statement run times, not elapsed times, but run times
• Do SQL statement run time data analysis (both numeric and visual)
• Use ASH to analyze parsing, sorting, shared pool, library cache, PQ issues and much more
• Create a network diagram visualization of an incident
• Use ASH to identify peak workloads of any type
• Learn where there are unexplored ASH performance analysis opportunities

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: Exploiting raw ASH data analysis

• Why ASH GUIs and canned reports are insufficient
• Sample based analysis. It's different!
• AWR or ASH. Which is better?
• ASH ScratchPad. Our ASH focused toolkit
• Setting the analysis scope. Knowing where to look

Session 2: Random incident analysis mastery

• ASH internals and parameters
• "Rock Drop" (ground zero) zoom-in analysis
• Variable summary timeline analysis
• Sample-by-sample timeline analysis
• Case Study: Random short but critical table locks
• Case Study: Deadlocks that "can't happen" but did

Session 3: Using raw ASH data in unconventional and powerful ways​

• Case Study: SQL run time and data analysis
• Case Study: Log file sync wait event analysis
• Case Study: Out of Oracle TEMP space analysis
• Case Study: Visualizing incidents using a network diagram
• Case Study: Using ASH to solve the, "It's not the database!" challenge
• Where the ASH "gold" resides

Details: 

Class Hours: There are 6 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!

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 to an active Oracle system. You can connect to Oracle using the tool of your choice, such as SQL*Plus or SQL Developer. You will also need access to the v$ and DBA views, including v$active_session_history and dba_hist_active_sess_history. If you can tune Oracle from the command line, you can tune Oracle using any respectable GUI tool. Also, Craig only uses SQLPlus, so you can type exactly what he types.
• ASH is only available with Oracle Enterprise Edition with either the Tuning and/or Diagnostic Pack. Please check to ensure you can legally use ASH data.