Re: Oracle WAN performance questions

Good question !

I also have been fiddling around a lot with Net8 and parameters (arrayfetch, sdu, tdu) on WANs - nothing seems to help ... all our WAN users now use citrix - end of problem. Would be interesting to know what other people did who had this problem ....

"Nick Palmer" <nick_at_kcicorp.com> wrote in message news:uk0bes8tmqer61_at_corp.supernews.com...
> 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.
>
> Our problem is that every SQL query/statement that our application submits
> to remote Oracle server takes a hit of 100ms based on our timings. This is
a
> for every call made to Oracle, not just the very first. e.g., if our
> application makes 500 SQL queries that takes only 15 seconds to run on a
> local Oracle server, remote server takes additional 50 seconds to run the
> same set of queries.
>
> Just to add, we are using deferred mode in our code.
>
> Question is:
>
> 1) Why is the Oracle/SQL*Net/Net8 hitting us with 100ms latency, when the
> actual WAN latency is only 50ms? Can this be improved?
>
> 2) Should TNSPING always take more than double the PING time? If so, why ?
>
> 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.
>
>
Received on Thu Jul 25 2002 - 13:11:39 CDT