Oracle Pooling performance problems with concurrent connections

Hi all,

I'm using OracleConnectionCacheImpl. It is worked fine with unit tests (using small amount of connections). The pool creates logical connections and release them after the end of transaction.

But once in production, it works correctly for 1 hour. When the system warm up (with a load 3 times more than normal time), with many threads asking connections at same time, the pool tried to answer requests by creating many many connections which are released, but very slowly. So OracleConnectionCacheImpl keeps going in creating new connections ... Then the system freezes. At the end, i have 105 active connections and over 150 in the cache size. So there are around 50 connections lost ...

Someone has experienced such things? Any explanations? Any solutions to tune the performance?

Thanks a lot,

Stephane Received on Tue Sep 06 2005 - 11:48:53 CDT