Dedicated Connections Slow Down to 64bit 10gR1 TNS listener
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.
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.
Increase in request for connections via the TNS listener
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms