Enqueue Waits

Waits for enqueue are not specific to RAC environments. However, they have a higher impact in performance than in the single instance environments because the enqueues are globally coordinated. Enqueue management is handled at the Global Enqueue Services (GES) layer, which is responsible for enqueue operations. The initial allocation of the GES resources is based on the following initialization parameters:

Image DB_FILES

Image DML_LOCKS

Image ENQUEUE_RESOURCES ...

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.