V$SESSION_CURSOR_CACHE definition in Oracle Database 11.2
V$SESSION_CURSOR_CACHE

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')

home |  up