V$ENQUEUE_STATISTICS definition in Oracle Database 11.2

V$ENQUEUE_STATISTICS

select
  EQ_NAME,                                 -- EQ_NAME VARCHAR2(64)
  EQ_TYPE,                                 -- EQ_TYPE VARCHAR2(2)
  REQ_REASON,                              -- REQ_REASON VARCHAR2(64)
  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
  REQ_DESCRIPTION,                         -- REQ_DESCRIPTION VARCHAR2(4000)
  EVENT#                                   -- EVENT# NUMBER
from
  GV$ENQUEUE_STATISTICS
where
  INST_ID = USERENV('Instance')

home | up