As of Oracle 9i, MTS Server has been deprecated and replaced with Oracle Shared Server
Connection pooling is an option that enables Oracle to maximize the number of physical network connections to a multi-threaded server.
This is achieved using one or more of the following strategies:
- Sharing or pooling a dispatcher's set of connections among multiple client processes
- Re-using physical connections (making them available for incoming clients)
- Maintaining a logical session with the previous idle connection
The following MouseOver illustrates an example.
By using a time-out mechanism to temporarily release transport connections that have been idle for a specified time period, connection pooling will
"suspend" a previous connection and re-use the physical connection. When the idle client has more work to do, the physical connection is reestablished with the dispatcher. The next lesson discusses how to enable connection pooling.