Re: Slow tnsping

Matthias Hoys wrote:
> Hi,
>
> We have a Windows 2000 COM+ application server which seems to have a strange
> network issue when trying to reach the database server (8.1.7.4 on AIX 5.2).
> Tnsping seems to "hang" once in while (>2500 ms reply). Ping sometimes gives
> "request timed out" (but less than tnsping). I already tried adding a second
> listener and doing tnsping to that one but this didn't help, so I don't
> think the listener is "overloaded". Tnsping from other servers to the same
> database server doesn't show this behaviour. Sqlplus sometimes hangs for
> some seconds. I suspect some bizarre network or routing problem but i'm not
> sure how to debug this further. I enabled sqlnet tracing on the application
> server but didn't find anything "weird" in the trace file. I used statspack
> to generate a report for a 1 hour period and 12% of the waits are related to
> the "SQL*Net break/reset to client" event. There are about 2 logons per
> second.
>
> Any ideas ????
>
>
> Matthias

• check if the thruput is as expected
• check if ping have lost packets (to dbserver and other servers)
• check networkdriver (recent ?)
• check net config (teaming ? failover ?)

regards

stefan Kapitza Received on Thu Nov 24 2005 - 15:16:45 CST