My Oracle Support Banner

Shared Server (MTS) Diagnostics (Doc ID 1005259.6)

Last updated on JULY 27, 2022

Applies to:

Oracle Net Services - Version to [Release 8.1.5 to 12.1]
Oracle Database - Enterprise Edition - Version to [Release 8.1.5 to 12.1]
Information in this document applies to any platform.



This document contains information about the Shared Server configuration of the Oracle Database software and some of the SQL scripts necessary to gather diagnostic information with guidelines for interpreting results. Prior to Oracle 9.0, Shared Server was called Multi-Threaded Server; the name was changed to reflect the extensive enhancements made.


Skill level rating for this Article: Intermediate


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Architecture of the Shared Server Database Configuration
 Dispatchers: The Number Of Dispatchers
 Dispatchers: Shutting Down Dispatchers
 Dispatchers: Monitoring Performance
 Shared Servers: Setting the Quantity of Shared Servers
 Shared Server Performance
 Virtual Circuits and Sessions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.