Parameter SQLNET.RECV_TIMEOUT Not Effective For Shared Server Connections (Doc ID 789442.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version: 10.2.0.1.0 to 11.1.0.7.0 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

++ Shared server has been configured for database

++ SQLNET.RECV_TIMEOUT parameter is set in the sqlnet.ora file located on the server hosting the database

++ Dedicated connections coming in from the application, timeout when left idle for more than the value set for SQLNET.RECV_TIMEOUT

++ Where as connections established to the database via the dispacthers do not time out when left idle for more than the value set for SQLNET.RECV_TIMEOUT

++ The status of such sessions are seen as 'INACTIVE' in v$session view and due to a number of such inactive sessions the sessions limit at the database level is seen to hit intermittently

Cause

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 hundreds of Community platforms