To dump the current enqueue states use:
ALTER SESSION SET EVENTS 'immediate trace name enqueues level level';
Levels are:
Level | Description |
1 | Dump a summary of active resources and locks, the resource free list and the hash table |
2 | Include a dump of resource structures |
3 | Include a dump of lock structures |
The following ORADEBUG command has the same effect:
ORADEBUG DUMP ENQUEUES level