VIEW: SYS.GV_$QUEUE

Source

View Text - Preformatted

select "INST_ID","PADDR","TYPE","QUEUED","WAIT","TOTALQ","CON_ID" from gv$queue

View Text - HTML Formatted

SELECT "INST_ID"
, "PADDR"
, "TYPE"
, "QUEUED"
, "WAIT"
, "TOTALQ"
, "CON_ID"
FROM GV$QUEUE