Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020)


I have uploaded the 3-hour hacking session video into my YouTube channel in 2 parts.

Introduction and using ASH + wait chains for troubleshooting performance spikes

A case study of a complex Oracle performance problem

The slides are in SpeakerDeck:

FYI there were a few questions about using such techniques without Oracle’s built-in ASH (due to licensing and Oracle Standard Edition). You can look into the Simulated Oracle ASH (OraSASH) package and there’s also my ashtop.sql version adapted to run on OraSASH too:

Enjoy! :-)

Note that my blog has commenting enabled again (scroll down). You will need a GitHub account to comment.

  1. Check out my 2022 online training classes in a new format!
    Advanced Oracle SQL Tuning training. Advanced Oracle Troubleshooting training, Linux Performance & Troubleshooting training: Learn when it's convenient to you and get your training questions answered even months after taking the class!
  2. Get weekly updates by email or follow Social/RSS