The following command can be used to dump the global area
ALTER SESSION SET EVENTS 'immediate trace name global_area level level';
Levels are (bitmask):
Level | Description |
1 | Include PGA |
2 | Include SGA |
4 | Include UGA |
8 | Include indirect memory dumps |
The following ORADEBUG command has the same effect:
ORADEBUG DUMP GLOBAL_AREA level
The structure of the fixed SGA is externalised in X$KSMFSV which has the following columns:
Name | Type | Description |
ADDR | RAW(4) | |
INDX | NUMBER | |
INST_ID | NUMBER | |
KSMFSNAM | VARCHAR2(64) | Name |
KSMFSTYP | VARCHAR2(64) | Type |
KSMFSADR | RAW(4) | Address |
KSMFSSIZ | NUMBER | Size in Bytes |
This view can be queried using:
SELECT SUBSTR (ksmfsnam,1,20) AS "Name", SUBSTR (ksmfstyp,1,20) AS "Type", ksmfsadr AS "Address", ksmfssiz AS "Size" FROM x$ksmfsv;