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

  • From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
  • To: JDunn@xxxxxxxxx,John Dunn <JDunn@xxxxxxxxx>,"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 Apr 2018 10:09:07 +0100

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.

Other related posts: