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