Lesson 1

(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:

1. Define types of Oracle listeners
2. Describe how Shared Server differs from a dedicated listener
3. Describe how the dedicated listener spawns connections
4. Identify the components of Shared Server
5. Describe how Shared Server handles incoming connections
6. Define the elements of Shared Server

The next lesson examines the underlying reasoning behind the development of Shared Server.

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.

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