Hi
Can anyone tell me what is "CONNECTION POOLING" in Oracle?
Printable View
Hi
Can anyone tell me what is "CONNECTION POOLING" in Oracle?
Connection pooling is a resource utilization and user scalability feature of MTS that enables you to maximize the number of network sessions over a limited number of connections to a dispatcher. This is achieved by sharing or pooling a set of connections.
By using a time-out mechanism to temporarily release network connections that have been idle for a specified period of time, connection pooling makes these network connections available for incoming clients, while still maintaining a network session with the idle network connection. When the idle client has more work to do, the network connection is reestablished with the dispatcher.