Skip Headers
V$QUEUE contains information on the shared server message queues.
V$QUEUE
PADDR
RAW(4 | 8)
Address of the process that owns the queue
TYPE
VARCHAR2(10)
Type of queue:
COMMON
DISPATCHER
QUEUED
NUMBER
Number of items in the queue
WAIT
Total time that all items in this queue have waited (in hundredths of a second). Divide by TOTALQ for average wait per item.
TOTALQ
Total number of items that have ever been in the queue