wan/lan oracle performance tuning

From: brasinhab <brasinhab_at_yahoo.com>
Date: 8 May 2003 12:16:27 -0700
Message-ID: <a4a13415.0305081116.44a7098d@posting.google.com>

I'm a newbie in oracle, but we are using a PDM application that was not developed by us, and trying to determine why the wan performance is poor, taking into account our wan speed. The difference in regular file transfer speed between lan and wan is about 3X (that is a 100mb X 32mb). On the other hand the application is about 9-10 times (!) slower on remote (wan) clients. We already know that the quality/quantity of sql is not optimized but we can't really modify the application. The response delay is primarily due to small sized sql transactions, but in large quantity.

BTW, The latency is 60ms. And servers/clients are AIX.

Is there any oracle/network parameters I could investigate to improve this performance? We are currently getting test results on tcp.nodelay=true. Any advice would be welcome. Thanks,

Hetty. Received on Thu May 08 2003 - 14:16:27 CDT