Oracle Database Discussions

Hi Everyone,

Good day!

I've posted an almost similar question regarding this topic. In that post, I have asked for troubleshooting methods I can take to optimize/improve the poor performance of our Oracle deployment on two sites. Unfortunately, we have not solved the case yet and our in-house Oracle DBA is almost giving up on the situation.

This time, I would like to seek your opinions on whether the below setup is "acceptable" or a workable solution. If not, I'd appreciate opinions from Oracle experts and professionals as to what direction should we take to achieve near-LAN performance on a WAN link. If anyone here has a similar setup, kindly post your current implementation setup, too.

Here's our basic setup:
=================================
Site 1:
Oracle Database Server
App Server
Clients

Site 2:
Oracle App Server
Clients

Both sites are linked via a 1mbps MPLS line (on Cisco routers).

Clients on Site 1 have good transaction performance but clients on Site 2 have very bad performance (e.g. a single transaction takes 20 minutes to complete).
=================================

From what I've read and skimmed on some articles and forum threads, to achieve a near-LAN performance for this type of setup, application of a Citrix solution or a Cisco WAAS solution are great options.

Problem is, the management is keen on utilizing the current infrastructure and having the above setup work without any purchase additions (whether hardware or software). Your inputs will help us convince the management or sell the idea that the above setup will really require add-ons (if that is really the case) that need purchasing.

Thank you very much. Any input will be of great help.