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