Oracle7 Server Administrator's Guide
Modifying Server Processes
This section describes changes you can make after starting an instance, and includes the following topics:
Changing the Minimum Number of Shared Server Processes.
After starting an instance, you can change the minimum number of shared server processes by using the SQL command ALTER SYSTEM.
Oracle7 eventually terminates dispatchers and servers that are idle longer than the minimum limit you specify.
If you set MTS_SERVERS to 0, Oracle7 will terminate all current servers when they become idle and will not start any new servers until you increase MTS_SERVERS. Thus, setting MTS_SERVERS to 0 effectively disables the multi-threaded server temporarily.
To control the minimum number of shared server processes, you must have the ALTER SYSTEM privilege.
The following statement sets the number of shared server processes to two:
ALTER SYSTEM SET MTS_SERVERS = 2
Adding and Removing Dispatcher Processes
You can control the number of dispatcher processes in the instance. If the V$QUEUE and V$DISPATCHER views indicate that the load on the dispatcher processes is consistently high, start additional dispatcher processes to route user requests without waiting; you may start new dispatchers until the number of dispatchers equals MTS_MAX_DISPATCHER. In contrast, if the load on dispatchers is consistently low, reduce the number of dispatchers.
To change the number of dispatcher processes, use the SQL command ALTER SYSTEM. Changing the number of dispatchers for a specific protocol has no effect on dispatchers for other protocols.
You can start new dispatcher processes for protocols specified in the MTS_LISTENER_ADDRESS parameter and in the MTS_DISPATCHERS parameter. Therefore, you can add dispatchers only for protocols for which there are dispatchers; to start dispatchers for protocols for which there are currently no dispatchers, shutdown the database, change the parameter file, and restart the database.
If you reduce the number of dispatchers for a particular protocol, the dispatchers are not immediately removed. Rather, Oracle7 eventually terminates dispatchers that are idle for too long, down to the limit you specify in MTS_DISPATCHERS.
To control the number of dispatcher processes, you must have the ALTER SYSTEM privilege.
The following example adds a dispatcher process where the number of dispatchers was previously three:
ALTER SYSTEM
SET MTS_DISPATCHERS = 'TCPIP,4';
See Also: For more information about tuning the multi-threaded server, see the Oracle7 Server Tuning manual.