Oracle OCI Connection Pooling vs Oracle UCP -
i researching on various oracle jdbc connection pooling mechanisms , understand oracle offers 4 connection pooling mechanisms when oci driver used
- oracle datasource
- oracle oci connection pooling
- oracle ucp (universal connection pooling -recommended on oracledatasource)
- oracle database resident connection pooling
please correct me if wrong.
i wanted know pros , cons of using oracle ucp (universal connection pooling) compared oracle oci connection pooling provided oci driver.
please share thoughts/experience on topic.
i try adding details based on reading have done far.
below distinct features supported different connection pooling mechanisms
oracle ucp (universal connection pooling)
a. supports features fast connection failover (fcf), runtime connection load balancing , connection affinity.
b. jmx support
c. support labelling connections
d. support connection harvesting
oci (oracle call interface) connection pooling
a. support session multiplexing.
oracledatasource
a. implicit connection cache.
Comments
Post a Comment