On Apr 8, 2013, at 3:23 AM, Madan KN wrote: > *Hi All,* > > Currently we are using tomcat jdbc pooling for oracle 11g R12.
What version of Tomcat are you using? If you are using the pool directly outside of Tomcat, what version of it are you using? > The problem > we are facing is during the peak traffic (less than %2) of time the > connections spike up to more than 100 sessions & never comes back to the > normal / desired pool size. It would be helpful to see your configuration. Please post it here, minus comments. > Due to the connections are returned either in > Round-Robin/Random to the application. How are you determining this? Can you provide some background on why you think this is causing a problem? > > Is there a way we can try LIFO so that connections to evict idle / unwanted > pool size beyond certain limit? Not sure exactly what you mean here. Is the "fairQueue" option what you are looking for? https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html Dan > > *Madan KN* --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org