Oracle Internals
JulianDyke.com

Welcome

Consultancy

Seminars

Blog

Presentations

Diagnostics

Internals

 

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