The preceding lesson examined the first three init.ora dispatcher parameters required to initialize MTS.
This lesson examines the critical
controls the number of dispatcher processes started at instance startup.
You must estimate the number of dispatchers to start for each network protocol before instance startup. The optimal number of dispatcher processes for each instance depends upon:
- The performance you want from your database
- The host operating system's limit on the number of connections per process
- The number of connections required per network protocol
The instance must be able to provide as many connections as there are concurrent users on the database system.
More dispatchers means users do not have to wait as long for dispatcher service.
Once you know the number of possible connections per process for your operating system, you can calculate the initial number of dispatcher processes per network protocol to create during instance startup, using the following formula:
When several listeners are defined (or you are using SQL*Net 1.0 and 2.0), the user may connect to the server either via a dedicated server or via the MTS. The next lesson examines the remaining three init.ora parameters required to initialize MTS.