SQL*Net expire_time parameter
From: Bob Blizard <rblizard_at_bb.cmcsys.com>
Date: 1995/07/18
Message-ID: <3ugdh6$es0_at_caesar.ultra.net>#1/1
Date: 1995/07/18
Message-ID: <3ugdh6$es0_at_caesar.ultra.net>#1/1
I am trying to figure out how the SQL*Net V2 parameter SQLNET.EXPIRE_TIME works. I know that I can set a value in minutes for it, and that it uses tcp's keepalive to check for a connection and keep or kill the connection.
I am hoping it is the former, since we need to be able to kill dropped connections which may have row-level locks on them from SELECT... FOR UPDATE statements. If it is the latter, people would have to stay completely off until after the expire_time passes.
Any input on this gratefully accepted.
-- Bob Blizard rblizard_at_cmcsys.com | All these worthwhile CMC Systems, Inc. | opinions are mine, and 175 Littleton Rd Westford, MA 01886 | not necessarily CMC's... Ph (508) 392-1300 Fax (508) 392-1303 | "If you want to park in the first row of life, you must go there to look for a space."Received on Tue Jul 18 1995 - 00:00:00 CEST