Dedicated Connections Slow Down to 64bit 10gR1 TNS listener (Doc ID 368951.1)

Last updated on MARCH 18, 2009

Applies to:

Oracle Net Services - Version: 10.1.0.2.0 to 10.1.0.5.0
This problem can occur on any platform.
Dedicated connections to database slow down.

Symptoms

Connection time performance is slow for dedicated connections to 64bit Listener.

Particularly when requests for new connections is high or/and the listener is stressed or overloaded.

Shared Server connections do not slow down.

Sqlplus connections can take upto 45 seconds to complete.

Oracle net client trace shows the slow down is after the first connect packet has been sent.

[24-APR-2006 14:41:53:894] nttrd: entry
[24-APR-2006 14:42:25:566] nttrd: socket 252 had bytes read=8

Increasing the TNS Listener parameter QUEUESIZE and TCP parameters such as tcp_conn_req_max_q does not help.




Changes

Increase in request for connections via the TNS listener

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