This content has been marked as final. Show 2 replies
Answered here: http://stackoverflow.com/questions/13238479/how-to-make-oracle-ucp-always-store-several-available-connections/13247842#13247842
kite wrote:These days that isn't generally a problem that one needs to manage in detail for a standard data center set up.
My goal is to always have 2 available connections in pool so I wouldn't loose time for creating connections.
High volume (really high volume) applications that benefit from this often will measure that sort of time at such low levels that it nothing more than noise compared to processing for the rest of system. Not to mention of course that if the database API usage itself seems likely to be a bottleneck then designing for that rather than attempting to optimize it afterwards is going to provides significantly better performance.