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

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Mon, 16 Apr 2018 10:09:07 +0100
Message-ID: <9C749143-C6D8-441A-83EA-CBCFAE78C0D0_at_dunbar-it.co.uk>

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 - 11:09:07 CEST

This message: [ Message body ]
Next message: Sanjay Mishra: "Re: Big Complex MV creation and Refresh"
Previous message: John Dunn: "Oracle running under Amazon Web services : database connections timing out"
In reply to: John Dunn: "Oracle running under Amazon Web services : database connections timing out"
Next in thread: John Dunn: "RE: Oracle running under Amazon Web services : database connections timing out"
Reply: John Dunn: "RE: Oracle running under Amazon Web services : database connections timing out"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message