Oracle Connection Pooling through the LTM

What I have seen in the past is a mix of this issue mixed with firewalls also having timeouts of 30 minutes.

 

30 minutes is a long time!

 

 

So you end up in a situation where you have to set the timeout in a custom profile.

 

However the application server that has the connection pool should be configured so that you are validation the connections, using table validation and specifying a valid table is required for this as many other validation routines get cached in the client so defeat the purpose.

 

 

This is more of an application server centric issue really, you can expect to see errors like "Broken Pipe Exception" thrown when you have timeouts occur.

 

 

What we found was that some devices on timout dont FIN the connection they just RST and some app servers really hate that. Sun App server is especially bad at handling this situation and you quickly exhaust your available connections and need to restart the app server.