GV$BUFFERED_QUEUES definition in Oracle Database 11.2
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
oldest_msgid, -- OLDEST_MSGID RAW(16)
oldest_msg_enqtm, -- OLDEST_MSG_ENQTM TIMESTAMP(3)
elapsed_enqueue_time/10000, -- ELAPSED_ENQUEUE_TIME NUMBER
elapsed_dequeue_time/10000, -- ELAPSED_DEQUEUE_TIME NUMBER
elapsed_transformation_time/10000, -- ELAPSED_TRANSFORMATION_TIME NUMBER
elapsed_rule_evaluation_time/10000, -- ELAPSED_RULE_EVALUATION_TIME NUMBER
enqueue_cpu_time/10000, -- ENQUEUE_CPU_TIME NUMBER
dequeue_cpu_time/10000, -- DEQUEUE_CPU_TIME NUMBER
last_enqueue_time, -- LAST_ENQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
last_dequeue_time, -- LAST_DEQUEUE_TIME TIMESTAMP(3) WITH TIME ZONE
decode( -- QUEUE_STATE VARCHAR2(25)
bitand(flags, 1), 1, 'QUEUE IS IN RECOVERY MODE', 0, 'NORMAL')
from
x$buffered_queues
where
bitand(flags, 16) = 0