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

E40402-12
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
PDF · Mobi · ePub

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).