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