My Oracle Support Banner

Oracle Net (SQL*Net) Timeout Parameters (Doc ID 1560775.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version 11.2.0.1 and later
Information in this document applies to any platform.Goal

This document describes the following sqlnet.ora file parameters:

SQLNET.INBOUND_CONNECT_TIMEOUT=n
SQLNET.OUTBOUND_CONNECT_TIMEOUT=n
SQLNET.RECV_TIMEOUT=n
SQLNET.SEND_TIMEOUT=n
TCP.CONNECT_TIMEOUT=n
 

Note that each parameter is set in <n> seconds.

The default for SQLNET.INBOUND_CONNECT_TIMEOUT is 60 seconds.

The default for TCP.CONNECT_TIMEOUT is also 60 seconds. 

There is no default for the remaining parameters.  

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.