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:
Note that my blog has commenting enabled again (scroll down). You will need a GitHub account to comment.