Oracle Performance on WAN with T-1 line

Dear 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).

Also, If anyone knows about utilities to troubleshoot network performance problems for Oracle, or 'tuning' tools. I wouul appreciate your feedback very much.

Thanks in advance for your assistance.

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

http://www.smarteam.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 00:00:00 CDT