Re: Performance Tunning over WAN

Nuno Souto schrieb:
>
> You shouldn't have to be 100% for ORACLE. Does it go at that with a LAN?
> Probably not. If it is a typical C/S application, then you do NOT want it to use
> bandwidth at the rate of 100% solid. There will be short bursts, but that's it.
> It all depends on what the application is doing.
>
> --
> Cheers
> Nuno Souto
> nsouto_at_acay.com.au
> http://www.acay.com.au/~nsouto
> David Orr wrote in message <78ih9p$j6e_at_sjx-ixn5.ix.netcom.com>...
> >
> >I have a front end Client applicant programmed in Delphi accessing my Oracle
> >database.
> >
> >Problem is simply that the WAN is approximately 50 times slower than the
> >LAN. I am able to monitor the bandwidth while accessing the Oracle server
> >across WAN and never seem to go above 5% available bandwidth. However I can
> >transfer/retreive files at 100%+ bandwidth as well as access for example an
> >excel spreadsheet at 100%+ bandwidth. This leads me to believe that the
> >problem lies within Oracle.

Yes,

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.

Looking for an answer
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Wed Jan 27 1999 - 01:09:53 CST