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