Re: Performance over WAN with Latency of xx ms

On 9/22/05, Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com> wrote:
>
> Hi, By separating application server in one location and the database
> server in another location and the database connections will be across the
> WAN using both Oracle JDBC thin driver (9.2.0.5 <http://9.2.0.5>) and
> Oracle Net, How well the drivers perform over the WAN and what should be the
> max. network latency to get the acceptable performance. The database is in
> 9.2.0.5 <http://9.2.0.5>
> Thanks in Advance.
>

If the app code is already written, trace a session or examine session statistics.
Take an acceptable response time, subtract the app and db server cpu time, divide it by the number of sqlnet round trips completed by the app and there is your approximate acceptable max network latency for a round trip.

Perhaps a copy of Cary Milsap's book would provide you with the info that you seek.
http://www.oreilly.com/catalog/optoraclep/

In the sample chapter, there is hope:
"Optimizing Oracle response time is, for the most part, a solved problem."

Paul

--
http://www.freelists.org/webpage/oracle-l