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