../E40402-16.epub /> ../E40402-16.mobi />

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
EXPIRED_MSGSFoot 1  NUMBER   Number of expired messages
OLDEST_MSGIDFootref 1 RAW(16)   Message ID of the oldest message
OLDEST_MSG_ENQTMFootref 1 TIMESTAMP(3)   Enqueue time of the oldest message
QUEUE_STATEFootref 1 VARCHAR2(25)   Indicates whether the queue is in recovery mode (QUEUE IS IN RECOVERY MODE) or not (NORMAL)
ELAPSED_ENQUEUE_TIMEFootref 1 NUMBER   Total time spent in enqueue (in hundredths of a second)
ELAPSED_DEQUEUE_TIMEFootref 1 NUMBER   Total time spent in dequeue (in hundredths of a second)
ELAPSED_TRANSFORMATION_TIMEFootref 1 NUMBER   Total time for evaluating transformations (in hundredths of a second)
ELAPSED_RULE_EVALUATION_TIMEFootref 1 NUMBER   Total time for rule evaluations (in hundredths of a second)
ENQUEUE_CPU_TIMEFootref 1 NUMBER   Total CPU time for enqueue (in hundredths of a second)
DEQUEUE_CPU_TIMEFootref 1 NUMBER   Total CPU time for dequeue (in hundredths of a second)
LAST_ENQUEUE_TIMEFootref 1 TIMESTAMP(3)   Last message enqueue time
LAST_DEQUEUE_TIMEFootref 1 TIMESTAMP(3)   Last message dequeue time

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).