Which connection cache should I use, OracleConnectionCacheImpl, the Implicit connection cache, or the Universal Connection Pool (UCP)?
You should use the new Universal Connection Pool. This new connection caching mechanism is driver, protocol, and database independent. It supports non-JDBC connections and JDBC connections to databases other than Oracle. When using Oracle JDBC it provides advanced Oracle features including: • connection attributes to stripe and reuse connections • a connection cache manager per VM to manage one or more connection caches • abandoned connection timeout to reclaim idle checked out connections etc. • Runtime Connection Load Balancing to allocate work to the best performing instances The Oracle Implicit Connection Cache is still supported, but we encourage you to transition to the UCP in the near future. Note that the old connection cache, OracleConnectionCacheImpl was desupported in 11.1. See this question.
Related Questions
- Which connection cache should I use, OracleConnectionCacheImpl, the Implicit connection cache, or the Universal Connection Pool (UCP)?
- Could D.C. afford universal health care if it were the sole jurisdiction involved in the insurance (pool)?
- Which connection cache should I use, OracleConnectionCacheImpl or the new Implicit connection cache?