Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

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