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