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