GV$SQL_SHARED_MEMORY definition in Oracle Database 11.2
GV$SQL_SHARED_MEMORY
select
/*+use_nl(h,c)*/
c.inst_id -- INST_ID NUMBER
kglnaobj, -- SQL_TEXT VARCHAR2(1000)
kglfnobj, -- SQL_FULLTEXT CLOB
kglnahsh, -- HASH_VALUE NUMBER
kglobt03, -- SQL_ID VARCHAR2(13)
kglobhd6, -- HEAP_DESC RAW(8)
rtrim(substr(ksmchcom, 1, instr(ksmchcom, ':', 1, 1) - 1)),-- STRUCTURE VARCHAR2(16)
ltrim(substr(ksmchcom, -(length(ksmchcom) - (instr(ksmchcom, ':', 1, 1))), (length(ksmchcom) - (instr(ksmchcom, ':', 1, 1)) + 1))),-- FUNCTION VARCHAR2(16)
ksmchcom, -- CHUNK_COM VARCHAR2(16)
ksmchptr, -- CHUNK_PTR RAW(8)
ksmchsiz, -- CHUNK_SIZE NUMBER
ksmchcls, -- ALLOC_CLASS VARCHAR2(8)
ksmchtyp, -- CHUNK_TYPE NUMBER
ksmchpar -- SUBHEAP_DESC RAW(8)
from
x$kglcursor c,
x$ksmhp h
where
ksmchds = kglobhd6 and kglhdadr != kglhdpar