Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle WAN performance questions

Re: Oracle WAN performance questions

From: Christoph Kukulies <kuku_at_accms33.physik.rwth-aachen.de>
Date: 15 Aug 2002 15:31:36 GMT
Message-ID: <ajghgo$asv$1@nets3.rz.RWTH-Aachen.DE>


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.de
Received on Thu Aug 15 2002 - 10:31:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US