DBA_HIST_PERSISTENT_SUBS displays STREAMS AQ persistent queue subscribers historical statistics information. This view contains snapshots of V$PERSISTENT_SUBSCRIBERS.

Column Datatype NULL Description
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
SUBSCRIBER_ID NUMBER NOT NULL Internal subscriber number
SUBSCRIBER_NAME VARCHAR2(30)   Name of the subscriber
SUBSCRIBER_ADDRESS VARCHAR2(1024)   Address of the subscribing agent
SUBSCRIBER_TYPE VARCHAR2(30)   Type of the subscriber:
  • PROXY - Propagation subscriber

  • SUBSCRIBER - Normal subscriber

  • RECIPIENT - Recipient

FIRST_ACTIVITY_TIME TIMESTAMP(6)   First subscriber activity time since database startup
ENQUEUED_MSGS NUMBER   Number of messages enqueued since FIRST_ACTIVITY_TIME
DEQUEUED_MSGS NUMBER   Number of messages dequeued since FIRST_ACTIVITY_TIME
AVG_MSG_AGEFoot 1  NUMBER   Average age of messages in the queue
BROWSED_MSGSFootref 1 NUMBER   Number of messages that have been browsed
EXPIRED_MSGS NUMBER   Number of messages expired since FIRST_ACTIVITY_TIME
DEQUEUED_MSG_LATENCY NUMBER   Last dequeued message latency (in seconds)
LAST_ENQUEUE_TIME TIMESTAMP(6)   Timestamp of the last enqueued message
LAST_DEQUEUE_TIME TIMESTAMP(6)   Timestamp of the last dequeued message
ELAPSED_DEQUEUE_TIMEFootref 1 NUMBER   Total time spent in dequeue (in hundredths of a second)
DEQUEUE_CPU_TIMEFootref 1 NUMBER   Total CPU time for dequeue (in hundredths of a second)
DEQUEUE_TRANSACTIONSFootref 1 NUMBER   Number of dequeue transactions
EXECUTION_COUNTFootref 1 NUMBER   Number of executions of the dequeue index cursor

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