Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Our company has two branches, one in Malaysia and the other one in India. The problems occur when we try to share one of our Oracle environments to our branch in India; the connection is very slow, and we are looking for a way with have high speeds for both branches but our company doesn't want spend lots of money for new servers.

What is your suggestion? Right now we create one environment in the India branch & we connect from Malaysia. Most of the time session will expire during applying the fixes.

How we can increase the speed & what is your suggestion for sharing one environment between two countries.

I suggested they hire a server between two county so speed will become higher but they didn't accept it because most of them are expensive....

share|improve this question

2 Answers 2

If the network connection between the two sites is too slow, your options in general would be to improve the speed of the network connection or to reduce the amount of traffic being sent over the network. Improving the speed of the network connection would undoubtedly cost money. If you have a particularly chatty application, you could potentially improve the networking layer to be more efficient.

If local users are doing mostly selects with relatively few updates and inserts, separate servers may improve the situation. If you're generating redo more quickly than the network can transmit it, however, the two systems will drift further apart. And you may need to make substantial changes to your application in order to allow it to work in a multi-master replication environment.

share|improve this answer
    
Much better than my just abandoned answer of "more bandwidth". –  Holocryptic May 14 '11 at 10:09

Do you have leased WAN connections between the offices? If you do you could consider some sort of WAN acceleration appliance. We've had fairly good luck with Riverbed products for this purpose. You reduce bandwidth and hopefully Oracle will respond quicker too (Riverbed has Oracle specific WAN acceleration).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.