My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

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

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References

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