Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

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