Oracle Performance on WAN (with T1 network)

Hello All !

We have a large customer using our application on a WAN.

Our application is not written using Oracle dev. tools but is base on an Oracle database (on NT) which is installed with the common parameters (standard installation of Oracle enterprise for Windows NT).

The clients access the database over a WAN, structured on a T-1 line which should provide pretty good performance. Unfortunately, the customer complains about performance.

I'm not familiar with the distances exactly, but I presume we're discussing the different factories in the same city.

Anyway, to cut a long story short, I would appreciate very much, if you pointed out to me which parameters in Oracle might help me boost the performance (init.ora or others).

Thanks in advance for your assistance.

Adi Kabazo

Adi Kabazo (AdiK_at_smarteam.com)
Technical Manager, Asia & Pacific
Smart Solutions Ltd. - The Technical Data Management Company

http://www.smarteam.com Received on Sun Jul 12 1998 - 08:01:20 CDT