3 Replies Latest reply: May 10, 2012 7:14 AM by 936420 RSS

    TRACE on CLIENT “nttrd” take a long time

    826954
      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!!!