GV$SQL_SHARED_MEMORY

select
/*+use_nl (h, c) */ 
c.inst_id,               -- INST_ID NUMBER
kglnaobj,                -- SQL_TEXT VARCHAR2(1000)
kglnahsh,                -- HASH_VALUE NUMBER
kglobhd6,                -- HEAP_DESC RAW(4)
rtrim                    -- STRUCTURE VARCHAR2(16)
  (substr (ksmchcom, 1, instr (ksmchcom, ':', 1, 1) - 1)),
ltrim                    -- FUNCTION VARCHAR2(16)
  (substr (ksmchcom, - (length (ksmchcom) - (instr (ksmchcom, ':', 1, 1))), (length (ksmchcom) - (instr (ksmchcom, ':', 1, 1)) + 1))),
ksmchcom,                -- CHUNK_COM VARCHAR2(16)
ksmchptr,                -- CHUNK_PTR RAW(4)
ksmchsiz,                -- CHUNK_SIZE NUMBER
ksmchcls,                -- ALLOC_CLASS VARCHAR2(8)
ksmchtyp,                -- CHUNK_TYPE NUMBER
ksmchpar                 -- SUBHEAP_DESC RAW(4)
from
x$kglcursor c,
x$ksmhp h 
where
ksmchds = kglobhd6 and kglhdadr != kglhdpar
home |  up  |  mailbox