Common Wait Events in Oracle Real Application Clusters Environment
In this section we will discuss some of the common wait events that you will see in
Oracle Real Application Clusters (RAC) environment.
global cache cr request
When a session is looking for a consistent read (CR) copy of the buffer cached by the remote instance, it waits on the global cache cr request event till the buffer is available in the local instance. Normally the holder constructs the CR version of the buffer and ships it to the requesting instance through the high speed interconnect. The wait ends when the CR buffer arrives at the local buffer cache.
From Oracle Database 10g Release 1, global cache cr request waits are known as gc cr request waits.
Depending on the mode ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
