Tuning Oracle Using

Advanced ASH Strategies

"I've recently attended OraPub's live virtual class 'Tuning Oracle Using Advanced ASH Strategies.' I've been able to discover the root cause of performance incidents that I could not understand without Oracle’s Active Session History (ASH). Craig demonstrates tools and techniques with deep explanations I could not have learned without his training. I recommend the tools and training highly."

Steve Gardiner, Senior Oracle Performance Consultant

Minneapolis, Minnesota, USA

Why should I attend this class?

  • To find the top SQL every time

    The "bomb" just went off and users are yelling, "It was like this random thing!" You will learn how to find the key SQL in 30 minutes, or less, in the first session of the class. BAM! You rock!

  • To be an ASH expert

    Be empowered to solve the world's trickiest Oracle performance problems.

  • To shift your mindset

    We rocket you from zero to sample-based analysis expert! You will be able to completely shift your analysis mindset from time-based analysis to statistical sample-based analysis. 

  • To have pinpoint accuracy and confidence

    Learn when an incident began, when it ended, who was involved and what they were doing.


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:

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

Class Outline:

Session 1: Incident "ground zero" analysis done in 30 minutes or less, guaranteed
Session 2: Exploiting sample-based analysis, like only ASH can do
Session 3: Incident analysis mastery, start to finish
Session 4. Visualizing the incident with ASH and Python
Session 5. Using ASH in new, unconventional and powerful ways​

Details: 

Class Hours: There are 10 hours of live, interactive webinar training divided into five 2-hour sessions. To maximize learning and to work with your busy schedule, there will be a 1-3 day gap between 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 Homework: After each live session, homework will be available for you to download. The homework consists of a series of investigative questions which allow you to personally experience the session concepts, increasing your retention. Any slides presented during the sessions will also be available for you to download.

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.
  • Time to do the homework. You can expect the homework to take between 30 to 60 minutes.
  • 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.

Welcome OraPub Members!

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