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

Configure ACFS on ASM Disk Group in Oracle Grid Infrastructure

  Step 1: Check Available Space in ASM Disk Group Verify the free space available in the ASM disk group before creating a new volume. [grid...