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$SHARED_SERVER

Synopsis

The V$SHARED_SERVER view returns one row for each shared server process. Table 7.6 describes the columns in this view.

Table G-6. V$SHARED_SERVER Column Descriptions

Column Name

Description

NAME

The name of the shared server, which is S000, S001, S002, and so forth. This name forms part of the operating system’s name for the shared server process.

PADDR

The shared server’s process address.

MESSAGES

The total number of messages handled by the shared server process.

BYTES

The total number of bytes in all the messages handled by the shared server process.

CIRCUIT

The address of the circuit currently being serviced. This matches a value in the CIRCUIT column of the V$CIRCUIT view.

IDLE

The cumulative amount of time that the shared server has been idle. This is in hundredths of a second.

BUSY

The cumulative amount of time that the shared server process has been busy. This is in hundredths of a second.

REQUESTS

The cumulative number of requests that this shared server process has taken from the common request queue and executed.

STATUS

The current status of the shared server process. This is one of the following values:

EXEC

The shared server process is executing a SQL statement.

QUIT

The shared server process is in the process of being terminated.

WAIT (ENQ )

The shared server process is waiting for a lock.

WAIT (SEND)

The shared server process is waiting to send data to the client.

WAIT (COMMON)

The shared server process is idle.

WAIT (RESET)

A break ...

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