DBA_HIST_PERSISTENT_QUEUES

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