GV$AQ1 definition in Oracle Database 11.2
GV$AQ1

select
  INST_ID,                                 -- INST_ID NUMBER
  KWQSIQID,                                -- QID NUMBER
  KWQSINWT,                                -- WAITING NUMBER
  KWQSINRD,                                -- READY NUMBER
  KWQSINEX,                                -- EXPIRED NUMBER
  KWQSIAVGMSGAGE,                          -- AVERAGE_MSG_AGE NUMBER
  KWQSINCO,                                -- TOTAL_CONSUMERS NUMBER
  KWQSITWT,                                -- TOTAL_WAIT NUMBER
  DECODE(                                  -- AVERAGE_WAIT NUMBER
    KWQSINCO, 0, 0, KWQSITWT/KWQSINCO) 
from
  X$KWQSI

home |  up