Global Cache Waits
The most common wait events in the RAC environment related to the global cache are: global cache cr request, global cache busy, and enqueue. We will discuss these wait events in detail and explain how to investigate the problem if excessive wait times are observed with these wait events.
global cache cr request
When a process requires one or more blocks, Oracle first checks whether it has those (blocks) in its local cache. The simple hashing algorithm based on the DBA (Data Block Address) is used to traverse the cache buffers chains, and a suitable lock is found if it is in the hash bucket. When a session requests a block(s) that was not found in its local cache, it will request that the resource master grant shared access ...
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.
