My Oracle Support Banner

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

Last updated on JANUARY 16, 2025

Applies to:

Oracle Net Services - Version 11.2.0.1 and later
Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A 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.