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: https://speakerdeck.com/tanelpoder/troubleshooting-complex-oracle-performance-problems 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 ...
