Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have built a web app that was performing very fast, until users from a third coutry (the majority) started using the application. Now its very slow.

I see from the logs that I keep getting ORA-12170: TNS:Connect timeout occurred when the usage is at the peak. How can I solve this?

Then what setup of apache would help speed up stuff? Load balancing, multiple instances?

Am running it on RHEL4

share|improve this question

"Connect timeout". A web app should generally have a connection pool permanently connected to the database. Setting up a database connection (and killing it at the end) is pretty expensive so it is not something you should be doing for each user.

Suggest you look at Database Resident Connection Pooling in 11g

share|improve this answer
the database is on a different machine, so the connection pooling you are talking abuot is to be implemented there or at the client? – Ngetha Nov 5 '09 at 6:09
There are changes at both the database and client end. Details in a white paper and you would probably get more detailed help at Oracle's PHP forum – Gary Nov 5 '09 at 22:02
thank you man!!!!!!!!!!!!!!! – Ngetha Nov 6 '09 at 9:55
+1 for both question and answer. – DCookie Nov 9 '09 at 19:21

Your Answer


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