Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
How to handle Oracle MAX Connection Limit Exceeded problem in PHP?

Hi All,
Our application is based on PHP & Ajax.
Occasionally, we are getting "Oracle MAX Connection Limit Exceeded " issue in our application.
We want to alert the user that some problem in oracle database connection.
We did the mistake to not taking care of db error handling.
Is there any way to handle wisely ? Instead of changing or handling errors in all ajax calls.
we have the common PHP & Js files in all the modules.
Any suggestions or feedback are welcome.
Thanks,
Renga
Answers
-
My suggestion would be to look at using Oracle 11g DRCP connection pooling. This should allow better resource sharing. Also, when there are too many connections, it blocks until one can be established.
If you can't use pooling, then do what you need to do to allow more connections: reduce the number of Apache processes, add memory to the DB server machine, increase the DB limit on 'processes' (see the "Configuring the Database For Testing" section in the testing chapter of The Underground PHP and Oracle Manual), etc.
I have a gut feeling that you are not even using persistent connections.
Regarding error management, you will still need to be able to handle unexpected errors.
-
Yeah I agree with you using Oracle 11g it is really easy to symbolize connection pooling...I am just still in a fix for arranging data in grids..Suggestions are welcome..!!!!
Google apps directory