Name
V$QUEUE
Synopsis
The V$QUEUE view returns one row for each MTS queue. Each dispatcher process has a response queue associated with it, and there is one common queue used for requests. Table 7.5 describes the columns in this view.
Table G-5. V$QUEUE Column Descriptions
|
Column Name |
Description |
|---|---|
|
PADDR |
The address of the process owning the queue. Each queue has a unique process address. |
|
TYPE |
The queue type, which is one of the following values:
|
|
QUEUED |
The number of items currently in the queue. |
|
WAIT |
The total amount of time, in hundredths of a second, that entries in the queue have had to wait before being processed. This value is cumulative from the time the queue is created. |
|
TOTALQ |
The total number of entries that have been processed through the queue. This value is cumulative from the time the queue is created. |