You will be able to:

• Understand the benefits of both time-based analysis and an ASH sample-based analysis
• Pinpoint when an incident began, when it ended, who was involved and what they were doing
• Jumpstart your analysis using OraPub's free BloodHound and Scratchpad ASH tool kits
• Determine SQL statement plan changes - when, how many, etc.
• Infer SQL statement wall time
• Develop an incident time-line to explain the mystery
• Watch and listen to Craig as he demonstrates the analysis process multiple times

Class Pricing:

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

Class Outline:

Session 1. Oracle Architecture

• Memory architecture
• Data architecture
• Process architecture

Session 2. Life Of An Oracle SQL Statement

• Review of prior session
• Oracle database time
• Parsing
• Executing
• Fetching

Session 3. Detecting performance problems

• Review from prior session
• OraPub 3-Circle analysis
• Oracle Time-Based Analysis
• Active Session History analysis

Session 4. Using An AWR/Statspack Report To Tune Oracle

• Review of prior session
• Oracle focused analysis
• Operating system focused analysis
• Application focused analysis
• Integrating your analysis
• Working your way to becoming an Oracle tuning expert

Details: 

Class Hours: There are 8 hours of live, interactive webinar training divided into four 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 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 SQLPlus, so you can type exactly what he types.

Bonus:

You will get free insight from Craig for one of your AWR/Statspack reports. You do the analysis, email your findings to Craig, and he will give you free feedback!