TNSPing delay times

From: Carles Fragoso i Mariscal <cfragoso_at_cesca.es>
Date: Tue, 19 Feb 2002 10:15:51 +0100
Message-ID: <a4t4m9$fv2$1@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 - 03:15:51 CST