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(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