Dumps
Latches
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
|