Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle WAN performance questions
Nick Palmer <nick_at_kcicorp.com> wrote:
> Hello Group,
> I've got a couple of questions that I was hoping somebody in this group
> might have the expertise to answer.
> Our application is encountering a performance problem related to the latency
> over the WAN. The PING time between the client and the server running Oracle
> 9i across this WAN is consistently between 40-50ms. There are about 4 or 5
> hops between the two sites, with the main pipe being 2 OC3 (155 MBps)
> connections. TNSPING returns between 100ms-120ms.
I'm examining a similar problem with a customer: Orcacle 8.0.5 server is remote on a WAN.
But only the first TNSPING value is a bit bad, giving
C:\> tnsping80 dbalias 10
yields 500ms followed by 10-20 ms all the way. So the first might be the name lookup.
But I read down the thread that tnsping isn't a sign for performance anyway. It could be an alarming sign when it's really bad.
I looked into this thread because I was hoping to find a performance measurement tool to trace down performance bottlenecks.
> 2) Should TNSPING always take more than double the PING time? If so, why ?
See above. Did you use the count option?
> 3) Will you get different performance if you use Oracle Names server instead
> of a local TNSNAMES.ORA file, given that SQL*NET/Net8 has to go out and
> resolve the Oracle information from the network and not local ?
> Thanks in advance
> Nick.
-- Chris Christoph P. U. Kukulies kukulies_at_rwth-aachen.deReceived on Thu Aug 15 2002 - 10:31:36 CDT