(MTS) Multi-Threaded Server has been deprecated starting with Oracle 9i.
The Multi-Threaded Server (MTS) is a legacy server that existed for Oracle 8i.
It has been replaced by the Oracle Shared Server.
This module looks at how Oracle Shared Server differs from a dedicated listener.
After completing this module, you will be able to:
Define types of Oracle listeners
Describe how Shared Server differs from a dedicated listener
Describe how the dedicated listener spawns connections
Identify the components of Shared Server
Describe how Shared Server handles incoming connections
Define the elements of Shared Server
The next lesson examines the underlying reasoning behind the development of Shared Server.
Historical Note regarding legacy technology
In a multi-threaded server (MTS) configuration, client user processes connect to a dispatcher. A dispatcher can support multiple client connections concurrently. Each
client connection is bound to a virtual circuit. A virtual circuit is a piece of shared memory used by the dispatcher for client database connection requests and replies.
The dispatcher places a virtual circuit on a common queue when a request arrives.
An idle shared server picks up the virtual circuit from the common queue, services the request, and relinquishes the virtual circuit before attempting to retrieve another
virtual circuit from the common queue. This approach enables a small pool of server processes to serve a large number of clients. A significant advantage of the
MTS model over the dedicated server model is the reduction of the use of system
resources, enabling the support of an increased number of users.
(MTS) Multi-threaded server ceases to exist beginning with Oracle 9i
Note: To visitors of this module.
Oracle 9i has renamed the (MTS) mutli-threaded server to Shared Server.
The shared-server architecture increases the scalability of applications and the number of clients that
can be simultaneously connected to the database