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

Oracle Exadata

  Hardware Architecture:- Oracle Exadata Database Machine employs a modern scale-out architecture encompassing database compute, storage, ne...