Slow Connections to Database from 9.2 / 10.1 Clients
(Doc ID 1069772.1)
Last updated on MARCH 03, 2010
Applies to:
Oracle Net Services - Version: 9.2.0.1 to 10.1.0.5 - Release: 9.2 to 10.1Information in this document applies to any platform.
Effects 10.1.0.2 to 10.1.0.4 clients
Effects 9.2.0.1 to 9.2.0.6 clients
Symptoms
Remote connections to database are slow. Oracle Net level 16 client trace of a slow connection, shows the time is lost after the connection handshake has been completed, and the last packet sent to the server, show the following sql statement "Select null from dual for update nowait" is run.o Client is sending this packet, inside the SQL can been seen
[13-JAN-2010 15:43:01:641] nspsend: 00 00 00 01 01 00 28 53 |......(S|
[13-JAN-2010 15:43:01:641] nspsend: 45 4C 45 43 54 20 4E 55 |ELECT.NU|
[13-JAN-2010 15:43:01:641] nspsend: 4C 4C 20 46 52 4F 4D 20 |LL.FROM.|
[13-JAN-2010 15:43:01:641] nspsend: 44 55 41 4C 20 46 4F 52 |DUAL.FOR|
[13-JAN-2010 15:43:01:641] nspsend: 20 55 50 44 41 54 45 20 |.UPDATE.|
[13-JAN-2010 15:43:01:641] nspsend: 4E 4F 57 41 49 54 00 01 |NOWAIT..|
o Delay is then seen, this is the client idle, waiting for answer from server.
[13-JAN-2010 15:43:01:641] nttrd: entry
[13-JAN-2010 15:44:06:690] nttrd: socket 412 had bytes read=132
o Client then receives packet from server
[13-JAN-2010 15:44:06:690] nsprecv: 132 bytes from transport
[13-JAN-2010 15:44:06:690] nsprecv: tlen=132, plen=132, type=6
[13-JAN-2010 15:44:06:690] nsprecv: packet dump
[13-JAN-2010 15:44:06:690] nsprecv: 00 84 00 00 06 00 00 00 |........|
[13-JAN-2010 15:44:06:690] nsprecv: 00 00 10 17 E7 E7 7B 99 |......{.|
[13-JAN-2010 15:44:06:690] nsprecv: E3 AA 3D ED 55 55 B1 A5 |..=.UU..|
[13-JAN-2010 15:44:06:690] nsprecv: 6A B7 D5 E3 78 6E 01 0D |j...xn..|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
Cause
Solution