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

  1. oracle datasource
  2. oracle oci connection pooling
  3. oracle ucp (universal connection pooling -recommended on oracledatasource)
  4. 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

  1. 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

  2. oci (oracle call interface) connection pooling

    a. support session multiplexing.

  3. oracledatasource

    a. implicit connection cache.


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -