V$BUFFERED_QUEUES

V$BUFFERED_QUEUES displays information about all buffered queues in the instance. There is one row per queue.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Identifier for the queue
`QUEUE_SCHEMA`	`VARCHAR2(30)`	Owner of the queue
`QUEUE_NAME`	`VARCHAR2(30)`	Name of the queue
`STARTUP_TIME`	`DATE`	Startup time
`NUM_MSGS`	`NUMBER`	Total number of messages currently in the buffered queue
`SPILL_MSGS`	`NUMBER`	Current number of overflow messages spilled to disk from the buffered queue
`CNUM_MSGS`	`NUMBER`	Cumulative total number of messages enqueued into the buffered queue since the database last started
`CSPILL_MSGS`	`NUMBER`	Cumulative total number of overflow messages spilled to disk from the buffered queue since the database last started