I have an Oracle server that's located in South America, Chile. The client sits in Rye, NY. The latency to the server is about 238ms. We are using 2 WAE-7371(s) in Rye and 1 WAE-674 in Chile. All devices are running version 4.1.1d. The overall performance is very slow for the client accessing the Oracle database. The client says it's taking minutes to bring up the reports; everything he does takes a very long time. This is the first time he is accessing the Oracle DB from Rye. Now, I was hoping the WAAS can help out with optimizing the Oracle traffic; it's getting full TFO acceleration. However, after taking a couple of packet captures from the client, there are about 8,000 application turns.
Is there any tweaking I can perform on the WAAS that may help this at all? Is there a layer-7 accelerator for Oracle database? Do I need to look at fine tuning the TCP send/receive buffer settings? The default TCP send/receive buffer settings is set to adaptive.