This module took a close look at how MTS is configured and used. The main points of this module include:
- MTS uses pre-allocated dispatcher processes to handle incoming requests.
- MTS dispatchers channel requests to MTS servers that are dynamically allocated and de-allocated as needed.
- If you bounce a listener, you must also bounce the database or the listener will process connections in dedicated mode.
- MTS can be configured for connection pooling to minimize resources on the server.
- You can define multiple MTS listeners for any database server.
- Listener load balancing can be used with the MTS to ensure that all incoming connections are processed rapidly.
v$dispatcher view can be used to determine the busy rate for each MTS dispatcher.
v$queue view can be used to determine the total wait time in the MTS server queues.
- Most of MTS parameters can be altered while Oracle is running with the
ALTER SYSTEM command.
You should now have all of the information that you need to successfully define and use MTS on an Oracle server.
This module introduced you to the following terms:
- Contention: A term used to describe many resources that are competing for a single database resource.
- Load balancing: The distribution of connections among Oracle listeners to ensure that incoming requests do not have to wait for a listener connection.
The next module examines the Oracle connection manager utility and how it is used in Oracle networking.