GLOBAL_AREA Dump

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;