This discussion is archived
3 Replies Latest reply: May 10, 2012 5:14 AM by 936420 RSS

TRACE on CLIENT “nttrd” take a long time

826954 Newbie
Currently Being Moderated
I set :
TRACE_LEVEL_CLIENT = 16
TRACE_FILE_CLIENT = client

get the trace file:

(4952) [17-3 -2012 09:36:52:781] nsdo: gtn=10, gtc=10, ptn=10, ptc=8155
(4952) [17-3 -2012 09:36:52:781] nscon: entry
(4952) [17-3 -2012 09:36:52:781] nscon: recving a packet
(4952) [17-3 -2012 09:36:52:781] nsprecv: entry
(4952) [17-3 -2012 09:36:52:781] nsprecv: reading from transport...
(4952) [17-3 -2012 09:36:52:781] nttrd: entry
(4952) [17-3 -2012 09:36:55:593] nttrd: socket 912 had bytes read=8
(4952) [17-3 -2012 09:36:55:593] nttrd: exit
(4952) [17-3 -2012 09:36:55:593] nsprecv: 8 bytes from transport
(4952) [17-3 -2012 09:36:55:593] nsprecv: tlen=8, plen=8, type=11
(4952) [17-3 -2012 09:36:55:593] nsprecv: packet dump
(4952) [17-3 -2012 09:36:55:593] nsprecv: 00 08 00 00 0B 00 00 00 |........|
(4952) [17-3 -2012 09:36:55:593] nsprecv: normal exit
(4952) [17-3 -2012 09:36:55:593] nscon: got NSPTRS packet
(4952) [17-3 -2012 09:36:55:593] nscon: no connect data
(4952) [17-3 -2012 09:36:55:593] nscon: exit (0)

the “nttrd ” take a long time:3s.what had happened?
and ping:

C:\>ping 192.168.6.101

Pinging 192.168.6.101 with 32 bytes of data:

Reply from 192.168.6.101: bytes=32 time<1ms TTL=254
Reply from 192.168.6.101: bytes=32 time<1ms TTL=254
Reply from 192.168.6.101: bytes=32 time<1ms TTL=254
Reply from 192.168.6.101: bytes=32 time<1ms TTL=254

Ping statistics for 192.168.6.101:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\>
and tnsping:
C:\>tnsping 192.168.6.101

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-3 -
2012 09:51:38

Copyright (c) 1997, 2005, Oracle. All rights reserved.


D:\Oracle\product\11.2.0\client_1\Network\Admin\sqlnet.ora


Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.6.101))(AD
DRESS=(PROTOCOL=TCP)(HOST=192.168.6.101)(PORT=1521)))
OK (2830 ms)

C:\>







thanks!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points