DBA_HIST_PERSISTENT_QUEUES displays STREAMS AQ persistent queues historical statistics information. This view contains snapshots of V$PERSISTENT_QUEUES.
| 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 |
QUEUE_ID |
NUMBER |
NOT NULL |
Identifier for the queue |
FIRST_ACTIVITY_TIME |
TIMESTAMP(6) |
First queue activity time since database startup | |
ENQUEUED_MSGS |
NUMBER |
Number of messages enqueued | |
DEQUEUED_MSGS |
NUMBER |
Number of messages dequeued
Note: This column will not be incremented until all the subscribers of the message have dequeued the message and its retention time has elapsed. |
|
ELAPSED_ENQUEUE_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing enqueue | |
ELAPSED_DEQUEUE_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing dequeue | |
ELAPSED_TRANSFORMATION_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing transformation | |
ELAPSED_RULE_EVALUATION_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing rule evaluation | |
ENQUEUED_EXPIRY_MSGS |
NUMBER |
Number of messages enqueued with expiry | |
ENQUEUED_DELAY_MSGS |
NUMBER |
Number of messages enqueued with delay | |
MSGS_MADE_EXPIRED |
NUMBER |
Number of messages expired by time manager | |
MSGS_MADE_READY |
NUMBER |
Number of messages made ready by time manager | |
LAST_ENQUEUE_TIME |
TIMESTAMP(6) |
Last message enqueue time | |
LAST_DEQUEUE_TIME |
TIMESTAMP(6) |
Last message dequeue time | |
LAST_TM_EXPIRY_TIME |
TIMESTAMP(6) |
Last time message was expired by time manager | |
LAST_TM_READY_TIME |
TIMESTAMP(6) |
Last time message was made ready by time manager |