Oracle Net8 Configuration and Troubleshooting

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: COMMON The queue is the common queue that feeds requests to shared server processes. DISPATCHER The queue is a dispatcher queue used to feed results back to a dispatcher, which can then feed them back to the client.
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.