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