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-perfor... 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.
Recent comments
2 years 52 weeks ago
3 years 12 weeks ago
3 years 16 weeks ago
3 years 17 weeks ago
3 years 21 weeks ago
3 years 42 weeks ago
4 years 11 weeks ago
4 years 40 weeks ago
5 years 25 weeks ago
5 years 25 weeks ago