Enqueue Tuning in Oracle RAC
Oracle RDBMS preserves the integrity of user data during simultaneous use of the same data block by using GCS. In addition to data blocks, end users can concurrently access many other shared resources. Oracle uses a queuing mechanism to ensure proper use of these shared resources. In an Oracle RAC environment, Global Enqueue Services (GES) protects and regulates access to these shared resources.
Enqueue wait is the time spent by a session waiting for shared resources. A user’s response time and hence the database performance might be negatively impacted if a user session spends a long time waiting for a shared resource (or an enqueue). Waiting for the updating of the control file (CF enqueue), of an individual row ...
Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition 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.
