Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Dumps

Work Areas

To dump the current workareas use

    ALTER SESSION SET EVENTS 'immediate trace name workareatab_dump level level';

Levels are (bitmask)

Level Description
1 Global SGA Info
2 Workarea Table (Summary)
3 Workarea Table (Detail)

The following ORADEBUG command has the same effect

    ORADEBUG DUMP WORKAREATAB_DUMP level