Re: tnsping : slow response time

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Mon, 26 Apr 1999 09:09:15 +0100
Message-ID: <37241F2B.F34E0706@capgemini.co.uk>

tnsping only talks to the listener not the database

Regards

Alex

Gerry Sinkiewicz wrote:

> 1. Ping just talks to the NIC on the pinged host.
>
> 2. Tnsping talks to the database and accesses tnsnames.ora as well
> as sqlnet.ora, where are they (this maybe one cause)? Is ONAMES being used?
>
> 3. Tnsping also talks to the listener on the server, there is
> a little overhead there, but should not be a problem cause.
>
> 4. How far away are client and server in miles/km? When I TNSPING
> about 1500 miles away I too get times in the 250ms to 300ms
> range using local naming and better with ONAMES, but not real
> quick (like <10ms which I do get for tnspings just with 1 mile).
>
> marcelf_at_my-dejanews.com wrote:
> >
> Text snipped due to ISP restrictions?
> >
> >
Received on Mon Apr 26 1999 - 03:09:15 CDT