Re: Performance Tunning over WAN

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Wed, 27 Jan 1999 12:19:56 -0800
Message-ID: <Pine.OSF.4.02.9901271213460.20652-100000@gonzo.wolfenet.com>

On Wed, 27 Jan 1999, Matthias Gresz wrote:
>
> C/S apllications produce small bursts so that bandwith ought not been
> eaten up, but I encountered that even if you issue a "SELECT * FROM
> MY_TABLE") with some 5000 rows and fetch all the records the peak
> bandwith use is 30%. This is very poor since app is really slower over
> WAN than over LAN.

If you can get your application to use the array fetch interface, there will be fewer round trips when fetching data like this. The problem isn't so much the speed of the WAN, but the latency. You want to reduce the number of round trips as much as possible. You can monitor this statistic for a session in the v$sesstat fixed view.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Wed Jan 27 1999 - 14:19:56 CST