V$ENQUEUE_STAT definition in Oracle Database 11.2
V$ENQUEUE_STAT

select
  INST_ID,                                 -- INST_ID NUMBER
  EQ_TYPE,                                 -- EQ_TYPE VARCHAR2(2)
  TOTAL_REQ#,                              -- TOTAL_REQ# NUMBER
  TOTAL_WAIT#,                             -- TOTAL_WAIT# NUMBER
  SUCC_REQ#,                               -- SUCC_REQ# NUMBER
  FAILED_REQ#,                             -- FAILED_REQ# NUMBER
  CUM_WAIT_TIME                            -- CUM_WAIT_TIME NUMBER
from
  GV$ENQUEUE_STAT
where
  INST_ID = USERENV('Instance')

home |  up