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