Work Areas Dump

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