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;