V$LATCH_MISSES definition in Oracle Database 11.2

V$LATCH_MISSES

select
  PARENT_NAME,                             -- PARENT_NAME VARCHAR2(64)
  LOCATION,                                -- WHERE VARCHAR2(80)
  NWFAIL_COUNT,                            -- NWFAIL_COUNT NUMBER
  SLEEP_COUNT,                             -- SLEEP_COUNT NUMBER
  WTR_SLP_COUNT,                           -- WTR_SLP_COUNT NUMBER
  LONGHOLD_COUNT,                          -- LONGHOLD_COUNT NUMBER
  LOCATION                                 -- LOCATION VARCHAR2(80)
from
  GV$LATCH_MISSES
where
  inst_id = USERENV('Instance')

home | up