Oracle Connection Pooling through the LTM

Thanks for the response

 

 

Currently I have the have the F5 configured so that connections on TCP/1521 will not timeout at all. These application have low usage so the connections do timeout if the timeout is not set to infinite.

 

 

What I am looking for is if some has experience with a configuration of SQLNET so I do not have to have the connections set to infinite.

 

 

F5 is causing the issue but I am thinking the resolution is in the configuration of SQLNET.ORA.

 

 

We are going to test the following configuration but i am not sure if it will do the trick.

 

 

sqlnet.expire_time = 45

 

 

 

Possible values: 0-any valid positive integer! (in minutes)

 

Default: 0 minutes

 

Recommended value: 10 minutes

 

 

Purpose: Indicates the time interval to send a probe to verify the

 

client session is alive (this is used to reclaim wasteful

 

resources on a dead client)

 

 

 

We will set the F5 to timeout at 60mins and see what happens.

 

 

Ken