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

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...