Re: Ping and Oracle

From: Matthias Hoys <anti_at_spam.com>
Date: Wed, 8 Mar 2006 21:03:28 +0100
Message-ID: <440f3892$0$17014$ba620e4c@news.skynet.be>

> Request Time out
> Reply from 10.0.0.51: bytes=32 time<10ms TTL=128
> Reply from 10.0.0.51: bytes=32 time<10ms TTL=128
> Reply from 10.0.0.51: bytes=32 time<10ms TTL=128
>
> ........................
> Then will the sessions of users will get disconneted?
>
> I am using Oracle9iR2 on Windows2000. My clients are using Oracle Forms
> and Reports and they are experiencing intermittant connection and
> disconnection from the database.
> The alert log file shows nothing.
>
> regards.
>

Yes, this is a network problem and it will degrade your performance !!! We had a similar problem some months ago. Tnsping showed delays up to 2500 ms and users were complaining of slow applications. The root cause was an overloaded switch between the database server and the application servers. So please check this with your network administrator asap !

HTH
Matthias Hoys Received on Wed Mar 08 2006 - 14:03:28 CST