RAC Wait Event Enhancements in Oracle Database 10g

Starting from Oracle Database 10g, most of the RAC related wait events could be further classified into two types: place holder events and fixup events. For example, when a CR request is initiated, the outcome can be either a lock grant or a buffer. In other words, when a session is looking for a block in the global cache, it may not know whether it will get a buffer cached at remote instance or receive a lock grant to read the block from disk. The wait events tell precisely whether the session is waiting for a lock grant or buffer to arrive from other instance cache. This detailed breakup information is not available in previous versions because the complete wait time is charged to a single ...

Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.