I was recently involved in a discussion around why would a regular Oracle foreground session wait for the log file sequential read wait event. I then realized that I had never published my Hotsos Symposium 2014 talk about a relatively complex (treacherous?) Oracle performance issue involving multiple problems that “collide”. So I decided to run this presentation as a webinar next week + will demo some of my newer related scripts too!
- In this session Tanel will walk you through troubleshooting a yet another complex performance issue that he has faced in past. Again, the initial symptoms point to a different direction than the actual root cause, so a systematic approach was needed. You will see Tanel’s troubleshooting method in action and a bunch of (new) useful scripts to support it as well.
- Keywords: troubleshooting Oracle database performance spikes, cache buffers chains latch contention, log file sequential read waits, bugs, ora-600s
Date & Time:
- Jun 12, 2018 12:00 PM EDT
I will post the video to my Performance Tuning & Troubleshooting Youtube channel too!
See you soon!
I’m experimenting with Twitter to see if it’s a good forum for short blog comments & feedback
I'm running an advanced troubleshooting webinar next week: Troubleshooting a Complex Oracle Performance Issue.— Tanel Poder (@TanelPoder) June 7, 2018
It's a case study of a complex problem troubleshooting + useful ASH scripts.
Time: Tuesday Jun 12, 2018 12:00 PM EDT
See you soon!