Oracle Enqueues
The Enqueues Oracle metric are locks that serialize access to database resources. This event indicates that the session is waiting for a lock that is held by another session.
This query just shows sessions waiting for enqueue resources
SELECT sid, serial#, event, wait_class
FROM v$session WHERE event LIKE 'enq:%';
To get description of an enqueue resource use following query.
SELECT
eq_name "Enqueue",
ev.name "Enqueue Type",
eq.req_description "Description"
FROM v$enqueue_statistics eq, v$event_name ev
WHERE eq.event#=ev.event#
ORDER BY ev.name;