GV$SYSTEM_CURSOR_CACHE definition in Oracle Database 11.2

GV$SYSTEM_CURSOR_CACHE

select
  inst_id,                                 -- INST_ID NUMBER
  kgicsopn,                                -- OPENS NUMBER
  kgicshit,                                -- HITS NUMBER
  decode(                                  -- HIT_RATIO NUMBER
    kgicsopn,0,1,kgicshit/kgicsopn) 
from
  x$kgics

home | up