GV$BUFFERED_QUEUES

select
inst_id,                 -- INST_ID NUMBER
queue_id,                -- QUEUE_ID NUMBER
queue_schema,            -- QUEUE_SCHEMA VARCHAR2(30)
queue_name,              -- QUEUE_NAME VARCHAR2(30)
startup_time,            -- STARTUP_TIME DATE
num_msgs,                -- NUM_MSGS NUMBER
spill_msgs,              -- SPILL_MSGS NUMBER
cnum_msgs,               -- CNUM_MSGS NUMBER
cspill_msgs,             -- CSPILL_MSGS NUMBER
expired_msgs             -- EXPIRED_MSGS NUMBER
from
x$buffered_queues 
where
bitand (flags, 16) = 0
home |  up  |  mailbox