what is the recommended Inactive Connection Timeout for a db connection?
We support Pega applications and it uses prepared statements for most of the query executions and reuses the same db connection for multiple sessions. Enabling the setting "Inactive Connection Timeout" would force weblogic to reclaim the idle connections and add it back to the pool.
What would be the recommended timeout for this? Any issues that we need to be aware of relating to this setting?
Your help is appreciated.
-Ram