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 2021 online training classes here!
    Linux Performance & Troubleshooting training, Advanced Oracle Troubleshooting training, Advanced Oracle SQL Tuning training. In addition to the live online classes, all attendees will receive personal downloadable video recordings too!
  2. Get weekly updates by email or follow Social/RSS