In this video I will present a case study of a complex performance issue where the initial symptoms pointed somewhere else than the root cause. Only when systematically following through the troubleshooting evidence, 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.
Keywords & Symptoms
- buffer busy waits contention
- gc buffer busy acquire/release waits
- enq: TX - allocate ITL entry waits