GV$RESULT_CACHE_STATISTICS definition in Oracle Database 11.2
GV$RESULT_CACHE_STATISTICS

select
  INST_ID,                                 -- INST_ID NUMBER
  INDX + 1,                                -- ID NUMBER
  QESRCSTA_NAM,                            -- NAME VARCHAR2(128)
  decode(                                  -- VALUE VARCHAR2(81)
    QESRCSTA_VLO, QESRCSTA_VHI, to_char(QESRCSTA_VLO), QESRCSTA_VLO||'-'||QESRCSTA_VHI) 
from
  x$qesrcsta

home |  up