Latches Dump

To dump the current latch status use

  ALTER SESSION SET EVENTS 'immediate trace name latches level level';

Levels are:

Level Description
1 Latches
2 Include statistics

The following ORADEBUG command has the same effect:

  ORADEBUG DUMP LATCHES level