I would also traceroute to the database and verify the amount of hops.
On Tue, 19 Feb 2002 08:24:23 -0500, Jim Kennedy wrote:
> It just pings the listener. It does not connect to the database. How
> long does a ping take of the machine where the listener is running? If
> it is also 250ms, or there abouts then it is a network problem. Jim
> "Carles Fragoso i Mariscal" <cfragoso_at_cesca.es> wrote in message
> news:a4t4m9$fv2$1_at_noucreus-atm.cesca.es...
>> Hi,
>>
>> I'm obtaining around 250ms of time response with the TNSPING command on
>> a client. What could be the reasons of that kind of poor performance?
>>
>> Database tuning? Listener configuration? Network delay ?
>>
>> Anyone can tell me what's the purpose of a TNSPING command? Doing a
>> simple select or only a connection to a listener?!? Does a TNSPING
>> determine the performance of a DB or only the initial access time to
>> it?!?
>>
>> Thank you in advance
>>
>> Carlos
>>
>>
>>
>>
Received on Tue Feb 19 2002 - 10:04:58 CST
