To use CMAN’s connection concentration feature you must perform two tasks:
- Verify that the destination server is configured as a Multi-Threaded Server and verify that the multiplexing feature is turned on.
You can turn it on by setting the
mts_dispathers
parameter in each database’s init.ora file. The entry would be:
MTS_DISPATCHERS = (PROTOCOL=TCP) (MULTIPLEXING=ON)
- Route all client connection requests you want concentrated to the database server through the Connection Manager.
This step is accomplished by using the Net8 Assistant on the client. From Net8 Assistant choose Profile from the Network menu, then choose the General tab.
Oracle Connection Manager enables you to multiplex or funnel multiple client network sessions through a single transport protocol connection to a multi-threaded server destination.
Legacy: The Multi-Threaded Server (MTS) is a legacy server which existed for Oracle 8i.
The Multi-Threaded Server has been replaced by the Oracle Shared Server beginning with Oracle 9i.
Concentration reduces the demand on resources needed to maintain multiple connections between two processes by enabling the server to use fewer connection end points for incoming requests.
This enables you to increase the total number of network sessions that a server can handle. By using multiple Connection Managers, it is possible for thousands of concurrent users to connect to a server.