Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
V$QUEUE
contains information on the shared server message queues.
Column | Datatype | Description |
---|---|---|
PADDR |
RAW(4 | 8) |
Address of the process that owns the queue |
TYPE |
VARCHAR2(10) |
Type of queue:
|
QUEUED |
NUMBER |
Number of items in the queue |
WAIT |
NUMBER |
Total time that all items in this queue have waited (in hundredths of a second). Divide by TOTALQ for average wait per item. |
TOTALQ |
NUMBER |
Total number of items that have ever been in the queue |