Enqueue
Until Oracle9i Database, the enqueue wait event parameters are name and mode, ID1, and ID2. In Oracle Database 10g, the first parameter remains the same, but the second and third parameters provide specific information about the enqueue they represent. Depending on the enqueue wait event, it can fall under the Administrative, Application, Configuration, Concurrency, or Other wait class. Keep the following key thoughts in mind when dealing with the enqueue wait event.
Enqueues are locks that apply to database objects.
Enqueues are transactional, ...
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.
