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

.

Relevant Pages

  • Re: gdb help: debugging a segfault in boost::shared_ptr
    ... I am developing a database connectivity plugin for the Remedy Action ... I've developed a database pool for the plugin so the time ... The pool will also check if the connections are ... Thread-safe means that shared_ptr handle ...
    (comp.os.linux.development.apps)
  • Re: determining max pool size
    ... the larger the pool size, the more requests can be server. ... 500 open connections to SQL server I awfully lot.... ... close the connection without even executing the sql statement). ...
    (microsoft.public.dotnet.framework.aspnet)
  • JNDI Connection Pool issue
    ... I have found something strange with the jdk jndi connection pool. ... If you do not iterate over all the results returned by the query, ... private static HashMap connections; ... SearchResult searchResult= ...
    (comp.lang.java.programmer)
  • Re: MaxPoolSize - Recommendations
    ... Perhaps the pool is not leaking, ... using connections efficiently. ... for average 80 concurrent users. ... Microsoft doesn't have any recommendations concerning "max pool size" ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: meaning of max pool size ?
    ... Max Pool Size determines how many connections will be kept open (once ... If a connection string is different than any existing ... where distinct connection strings means ...
    (microsoft.public.dotnet.framework.adonet)