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.
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