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

home |  up