select
PADDR, -- PADDR RAW(8)
TYPE, -- TYPE VARCHAR2(10)
QUEUED, -- QUEUED NUMBER
WAIT, -- WAIT NUMBER
TOTALQ -- TOTALQ NUMBER
from
GV$QUEUE
where
inst_id = USERENV('Instance')