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.
Identifier for the queue
Owner of the queue
Name of the queue
First queue activity time since database startup
Number of messages enqueued
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.
Number of messages that have been browsed
Total time (in hundredths of a second) spent doing enqueue
Total time (in hundredths of a second) spent doing dequeue
Total time (in hundredths of a second) spent doing transformation
Total time (in hundredths of a second) spent doing rule evaluation