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.
29 янв 2020
