Dedicated vs. Oracle Database Tips by Donald Burleson. The Oracle multithreaded server MTS, later renamed "shared servers" was developed way-back in the days of Oracle7 when RAM was very expensive and RAM region sizes were severely limited by bit technology.
Enabling Session Multiplexing
2 - Articles Related
When building a library in DBCA, there are hints for us to choose the connection type. There are two types: dedicated server mode and shared server mode. The dedicated mode is used by default.
Question and Answer
Oracle Database creates server processes to handle the requests of user processes connected to an instance. A server process can be either of the following:. Your database is always enabled to allow dedicated server processes, but you must specifically configure and enable shared server by setting one or more initialization parameters. Figure , "Oracle Database Dedicated Server Processes" illustrates how dedicated server processes work. In this diagram two user processes are connected to the database through dedicated server processes. In general, it is better to be connected through a dispatcher and use a shared server process.
The shared server architecture enables a database server to allow many user processes to share very few server processes, so the number of users that can be supported is increased. With shared server, many user processes connect to a dispatcher. The dispatcher directs multiple incoming network session requests to a common queue. An idle shared server process from a shared pool of server processes picks up a request from the queue. This means a small pool of server processes can serve a large number of clients. Shared memory resources for dispatchers, virtual circuits, and shared servers are preconfigured to allow the enabling of shared servers at runtime. In configurations in which client load is causing a strain on memory and other system resources, database administrators can remedy load issues by starting shared server resources. You configure a protocol address with one of the following attributes:.