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

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...