GV$BUFFERED_QUEUESselect 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