Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from 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.

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.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata