select qid, sum(WAITING) waiting, sum(READY) ready, sum(EXPIRED) expired,
decode(sum(WAITING+READY+EXPIRED),0,0,max(average_msg_age)) average_msg_age,
decode(sum(TOTAL_CONSUMERS),0,0,max(TOTAL_WAIT)) total_wait,
decode(sum(TOTAL_CONSUMERS),
0, 0, TRUNC(max(TOTAL_WAIT)/max(TOTAL_CONSUMERS))) average_wait,
con_id
from gv$aq1 group by qid, con_id
SELECT QID
, SUM(WAITING) WAITING
, SUM(READY) READY
, SUM(EXPIRED) EXPIRED
,
DECODE(SUM(WAITING+READY+EXPIRED)
, 0
, 0
, MAX(AVERAGE_MSG_AGE)) AVERAGE_MSG_AGE
,
DECODE(SUM(TOTAL_CONSUMERS)
, 0
, 0
, MAX(TOTAL_WAIT)) TOTAL_WAIT
,
DECODE(SUM(TOTAL_CONSUMERS)
,
0
, 0
, TRUNC(MAX(TOTAL_WAIT)/MAX(TOTAL_CONSUMERS))) AVERAGE_WAIT
,
CON_ID
FROM GV$AQ1 GROUP BY QID
, CON_ID
|
|
|