sqlnet.expire_time [message #657254] |
Wed, 02 November 2016 18:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I have a problem with idle sessions being disconnected by a network load balancer. It could be fixed by setting a sqlnet.expire_time in the server's sqlnet.ora file so that the server would send a probe to the client every few seconds, but the server is an Oracle Cloud server and they won't change it just for me. Is there a way to configure the client to send something every few seconds to keep the session alive?
THank you for any insight.
|
|
|
|
Re: sqlnet.expire_time [message #657256 is a reply to message #657255] |
Wed, 02 November 2016 20:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Thank you for replying, but sqlnet.expire_time is one of the parameters that is effective only when set in the server side sqlnet.ora file. I need something that can be done on the client.
|
|
|