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.1
Information 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

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