GV$RESULT_CACHE_MEMORY definition in Oracle Database 11.2
GV$RESULT_CACHE_MEMORY

select
  INST_ID,                                 -- INST_ID NUMBER
  QESRCMEM_LAD,                            -- ID NUMBER
  QESRCMEM_CNK,                            -- CHUNK NUMBER
  QESRCMEM_BLK,                            -- OFFSET NUMBER
  decode(                                  -- FREE VARCHAR2(3)
    QESRCMEM_STA, 0, 'NO', 1, 'YES'),
  decode(                                  -- OBJECT_ID NUMBER
    QESRCMEM_STA, 0, QESRCMEM_OID, NULL),
  decode(                                  -- POSITION NUMBER
    QESRCMEM_STA, 0, QESRCMEM_POS, NULL) 
from
  x$qesrcmem

home |  up