GV$SESSION_CURSOR_CACHE
select inst_id, -- INST_ID NUMBER kgiccmax, -- MAXIMUM NUMBER kgicccnt, -- COUNT NUMBER kgiccopd, -- OPENED_ONCE NUMBER kgiccope, -- OPEN NUMBER kgiccopn, -- OPENS NUMBER kgicchit, -- HITS NUMBER decode -- HIT_RATIO NUMBER (kgiccopn, 0, 1, kgicchit/kgiccopn) from x$kgicc

home |  up  |  mailbox