Troubleshooting Complex Oracle Performance Issues - Part 1 (Hacking Session)
In this session I will demo some scenarios of how different components and layers of Oracle database work together and affect each other when one components hits a bottleneck. The main scenario is LGWR and commit interactions when redo log disk I/O writes are slow. I will do a live demo to dig deeper. When systematically following through the wait chains, we get to the root cause of the problem. This session aims to help you understand (and reason about) the Oracle’s multi-process & multi-layer system behavior, preparing you for independent troubleshooting of such complex performance issues in the future.
Watch video Troubleshooting Complex Oracle Performance Issues - Part 1 (Hacking Session) online, duration hours minute second in high quality that is uploaded to the channel Tanel Poder 30 January 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 8,223 times and liked it like visitors.
