Monday, April 8, 2013 12:31 AM
Currently we are using tomcat jdbc pooling for oracle 11g R12. 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. Due to the connections are returned either in Round-Robin/Random to the application.
Is there a way we can try LIFO so that connections to evict idle / unwanted pool size beyond certain limit?