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:
|
|
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 (11.2.0.2).