Keep Alive Setting in Oracle DB Server and Client

NeilZhang
NeilZhang
管理员
140
文章
106.8千
浏览
Oracle评论3,400字数 151阅读0分30秒阅读模式

In our daily work, one popular question is how to keep our session alive, especially for Oracle session.

I know there is a parameter named sqlnet.expire_time in the sqlnet.ora for such function in the DB server side, but if I want to do similar configuration in the Oracle client, how?

I searched in the Oracle Support website, and found this request could be fulfilled  by following ways:

  1. Add enable=broken in the tnsnames.ora file
  2. Adjust the tcp_keepalive_interval value in the OS

Please note for the item 1, the option must be placed in the right location, this is to say, it must directly below the ' (DESCRIPTION =' entry as below:

    (DESCRIPTION =
         (ENABLE=BROKEN) ####<<< Place entry here to enable to TCP KeepAlive mechanism

For the item 2, different OS has different way to change it, and you have to find it by yourself.

Windows

 
  • 本文由 NeilZhang 发表于14/03/2016 00:58:20
  • Repost please keep this link: https://www.dbcloudsvc.com/blogs/oracle/keep-alive-setting-in-oracle-db-server-and-client/
匿名

发表评论

匿名网友
:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:
确定