RE: Oracle running under Amazon Web services : database connections timing out

Is SQLNET.EXPIRE_TIME available in Oracle 11?

John Dunn
Senior Solutions Engineer
Sefas Innovation Limited.
Tel: + 44 (0) 117 910 0529
www.sefas.com<http://www.sefas.com/>
Advanced notice of holidays : 3rd April, 23rd-26 April 2018 With effect from 1st April 2017 my normal working days are Monday to Thursday

From: Norman Dunbar [mailto:oracle_at_dunbar-it.co.uk] Sent: 16 April 2018 10:09
To: John Dunn; John Dunn; oracle-l_at_freelists.org Subject: Re: Oracle running under Amazon Web services : database connections timing out

If I renember correctly, adding SQLNET.EXPIRE_TIME=15 does a probe every 15 minutes to check connections are alive and effectively is a keepalive. I've had to use this in the past. It goes on the server by the way, not the client.

Cheers,
Norm.

--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 16 2018 - 16:50:58 CEST