select
OPENS, -- OPENS NUMBER
HITS, -- HITS NUMBER
HIT_RATIO -- HIT_RATIO NUMBER
from
GV$SYSTEM_CURSOR_CACHE
where
inst_id = USERENV('Instance')