Untitled Document

Oracle Internals

Dumps

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