Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_HIST_BUFFERED_QUEUES

DBA_HIST_BUFFERED_QUEUES displays historical information about all buffered queues available for the instance.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
QUEUE_SCHEMA VARCHAR2(30) NOT NULL Owner of the queue
QUEUE_NAME VARCHAR2(30) NOT NULL Name of the queue
STARTUP_TIME DATE NOT NULL Startup time of the instance
QUEUE_ID NUMBER NOT NULL ID of the queue
NUM_MSGS NUMBER   Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk)
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 buffered queue was created.
CSPILL_MSGS NUMBER   Cumulative total number of overflow messages spilled to disk from the buffered queue since the buffered queue was created