V$PERSISTENT_QUEUES
displays information about all active persistent queues in the database since the queues' first activity time. There is one row per queue. 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 |
FIRST_ACTIVITY_TIME |
TIMESTAMP(6) |
First queue activity time since database startup |
ENQUEUED_MSGS |
NUMBER |
Number of messages enqueued |
DEQUEUED_MSGS |
NUMBER |
Number of messages dequeued
Note: This column will not be incremented until all the subscribers of the message have dequeued the message and its retention time has elapsed. |
BROWSED_MSGS |
NUMBER |
Number of messages that have been browsed |
ELAPSED_ENQUEUE_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing enqueue |
ELAPSED_DEQUEUE_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing dequeue |
ELAPSED_TRANSFORMATION_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing transformation |
ELAPSED_RULE_EVALUATION_TIME |
NUMBER |
Total time (in hundredths of a second) spent doing rule evaluation |
ENQUEUED_EXPIRY_MSGS |
NUMBER |
Number of messages enqueued with expiry |
ENQUEUED_DELAY_MSGS |
NUMBER |
Number of messages enqueued with delay |
MSGS_MADE_EXPIRED |
NUMBER |
Number of messages expired by time manager |
MSGS_MADE_READY |
NUMBER |
Number of messages made ready by time manager |
LAST_ENQUEUE_TIME |
TIMESTAMP(6) |
Last message enqueue time |
LAST_DEQUEUE_TIME |
TIMESTAMP(6) |
Last message dequeue time |
LAST_TM_EXPIRY_TIME |
TIMESTAMP(6) |
Last time message was expired by time manager |
LAST_TM_READY_TIME |
TIMESTAMP(6) |
Last time message was made ready by time manager |