How good is Oracle Universal Connection Pool (UCP)

Question

Does anybody have experience with using Oracle UCP under real production load? Does it handle database reconnects well? Are there any multi-threading issues? Has anybody compared it with C3P0 or Apache DBCP?

Answer 1

hi

by using the connection pooling(IBM RAD) to oracle i am getting faster results.when compared to the normal programming concept.in the connection pooling properties, by defaults the max no.of connections is 10,and the ideal time out is 180 sec.

here we can set up the max.of users users access at a time....

Answer 2

I've seen multiple customers using UCP in production. I've seen none of the issues you are concerned about. It performs quite well under load. And can handle reconnects. The reconnect policy is configurable. It also supports RAC quite well.

But the real upside to using a commercial connection pool is that someone is responsible for any problems you have. You would be surprised how many people try to develop and maintain their own connection pool.

Answer 3

I have used UCP in a system with around 10 transactions per seconds (mean) and 360 transactions per seconds peak, and no problems yet. (Number is per app server with 8 servers)

However the main benefits you get from UCP is when you are using Oracle RAC and the TAF/FAN functionality, UCP with Dataguard or if you are running something outside an appserver.