Toad World Blog

Oracle Multi-Threaded Server - V9.0-V9.2 Enhancements

Mar 12, 2013 1:25:00 PM by Quest Software

Oracle9i has renamed the multi-threaded server (MTS) 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. The shared server architecture also enables existing applications to scale up without making any changes to the application itself.

Several parameter names have been added and changed regarding the shared server. Oracle suggests that you use the new parameters in place of the depreciated ones. The new parameters and the old parameters they replace are as follows:

Old Parameter New Parameter
mts_dispatchers dispatchers
mts_max_dispatchers max_dispatchers
mts_servers shared_servers
mts_max_servers max_shared_servers
mts_circuits circuits
mts_sessions shared_server_sessions

 

Oracle has redesigned the connection protocols between the client process, the Oracle listener, and the dispatcher process, simplifying the process. This new direct handoff connection reduces network overhead and reduces the overall amount of network traffic required to create a connection between the client and the dispatcher process.

The dispatcher process has been improved, and network and database events are now handled using a common internal event model. This new event model reduces the overall CPU requirement of the dispatcher process and facilitates much more efficient networking.

Finally, you can use Oracle9i's OEM performance manager, part of OEM's performance pack, to monitor shared-server dispatchers, shared servers, and listeners. This product simplifies the management of shared servers through its GUI.

Note: Oracle9i databases running shared servers can support the dbms_ldap package. This was not the case in Oracle8i.

Tags: Oracle Spotlight on Oracle Wiki

Quest Software

Written by Quest Software