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.