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