Performance Tunning over WAN

From: David Orr <dorr_at_plastacq.com>
Date: Mon, 25 Jan 1999 12:34:47 -0700
Message-ID: <78ih9p$j6e@sjx-ixn5.ix.netcom.com>

Being new to Oracle I need some help tunning an Oracle server to run effectively over a WAN.

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.

WAN is framerelay with T1 pipes out of both sites and a 384cir with a T1 pipe speed across the cloud.

Any help would be greatly appreciated. Received on Mon Jan 25 1999 - 13:34:47 CST