Quote:
Originally posted by jodie
When exactly is the SQLNET.ORA file read? For example, if I set the SQLNET_EXPIRE_TIME = 5, does the DB check for Dead Connections every 5 minutes from that time on? Or is it by session in that every session that connects after it is set to 5 will be checked every 5 minutes?
Everytime a session connects to server, as you are setting this parameter at server level. Yes, DB server DCD probs to see is there any dead connection sitting around for every 5 minutes if you set it to 5. I did little reaserach on this and there are little caveats on this parameter setting as it depends on SYSTEM TCP/IP time out parm setting. My Sysadmin says are other issues to set this TCP/IP parm set to a different value than default/ currently set value.