Disclaimer

Thursday, 2 September 2021

SQLNET timeout parameters


SQLNET.EXPIRE_TIME=20 : to send a probe to verify that client/server connections are active every 10 mins.


SQLNET.RECV_TIMEOUT=600 : to specify the time, in seconds, for a database server to wait for client data after connection establishment. A client must send some data within the time interval.


SQLNET.INBOUND_CONNECT_TIMEOUT=60 : parameter to specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.



No comments:

Post a Comment

Index rebuild online in Oracle - shell script

  [oracle@rac10p reorg]$ cat index_rebuild_EMP.sh #!/bin/ksh export ORACLE_HOME=/oracle/K12/19 export ORACLE_SID=K12 export PATH=$PATH:/$ORA...