RelationalDBDesign 





Network Config   «Prev  Next»
Lesson 1

Using the Shared Server

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

Learning objectives

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.


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.
Figure 4 - 1 Oracle Database Dedicated Server Processes
Figure 4 - 1 Oracle Database Dedicated Server Processes

(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