Oracle Database Administration: The Essential Refe

Multi-Threaded Server

These views provide information on how the Multi-Threaded Server is configured and performing:

V$CIRCUIT

Contains information about the virtual circuits used to connect users to the instance.

V$DISPATCHER

Provides information about the various configured Dispatcher processes.

V$DISPATCHER_RATE

Provides statistics about the Dispatcher processes throughput.

V$MTS

Provides information about the overall activity of the Multi-Threaded Server.

V$QUEUE

Provides statistics about the multi-threaded message queue.

V$REQDIST

Provides a 12-bucket histogram of the distribution of request service times. This width-balanced histogram shows the number of hits in each of the 12 consistent times. The sizes of the buckets are allowed to change over time.

V$SHARED_SERVER

Shows the status of the each of the shared servers.