DBA_HIST_PERSISTENT_SUBS

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