GV$QUEUE
select inst_id, -- INST_ID NUMBER kmcqspro, -- PADDR RAW(4) decode -- TYPE VARCHAR2(10) (indx, 0, 'COMMON', 'DISPATCHER'), kmcqsncq, -- QUEUED NUMBER kmcqswat, -- WAIT NUMBER kmcqstnc -- TOTALQ NUMBER from x$kmcqs where indx=0 or kmcqspro!=hextoraw ('00')

home |  up  |  mailbox