V$SYSTEM_CURSOR_CACHE definition in Oracle Database 11.2
V$SYSTEM_CURSOR_CACHE

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

home |  up