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

home |  up  |  mailbox