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. |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access