V$PERSISTENT_SUBSCRIBERS displays information about all active subscribers of the persistent queues in the database. There is one row per instance per queue per subscriber. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column Datatype Description
QUEUE_ID NUMBER Identifier for the queue
QUEUE_SCHEMA VARCHAR2(30) Owner of the queue
QUEUE_NAME VARCHAR2(30) Name of the queue
SUBSCRIBER_ID NUMBER Internal subscriber number
SUBSCRIBER_NAME VARCHAR2(30) Name of the subscriber
SUBSCRIBER_ADDRESS VARCHAR2(1024) Address of the subscribing agent
PROTOCOL NUMBER Protocol 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
BROWSED_MSGS 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