Re: [PHP-DB] Multiple Oracle connections
Have you talked to the dba to see if the Oracle DB will accept more than one thread from the apache server? Bastien From: Christopher Jones <[EMAIL PROTECTED]> To: Chris Back <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Multiple Oracle connections Date: Mon, 04 Oct 2004 16:44:10 +1000 Chris Back wrote: Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems begin to occur. The first script running gets a connection to the database, start performing queries, etc. While the first connection is running all other pages hang while trying to connect to the database until the first page finishes. I have tried all of the following to no avail: oci_connect, oci_new_connect, and oci_pconnect. The results are always the same, only one connection opens, all others end up waiting. I have found that I can connect to the DB through other methods at the same time (jdbc, sqlplus). Is it possible I have configured something incorrectly or I have the wrong expectations? I could not find anything on the web concerning this issue and I know there must be much higher traffic installations that would have experienced this issue if it was widespread. Any help would be greatly appreciated. -Chris Back Using PHP5 and Apache 2 sounds daring. What platform are you on? If you can track down more information, file a bug at http://bugs.php.net/. Also see http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Take charge with a pop-up guard built on patented Microsoft® SmartScreen Technology. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Multiple Oracle connections
Chris Back wrote: Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems begin to occur. The first script running gets a connection to the database, start performing queries, etc. While the first connection is running all other pages hang while trying to connect to the database until the first page finishes. I have tried all of the following to no avail: oci_connect, oci_new_connect, and oci_pconnect. The results are always the same, only one connection opens, all others end up waiting. I have found that I can connect to the DB through other methods at the same time (jdbc, sqlplus). Is it possible I have configured something incorrectly or I have the wrong expectations? I could not find anything on the web concerning this issue and I know there must be much higher traffic installations that would have experienced this issue if it was widespread. Any help would be greatly appreciated. -Chris Back Using PHP5 and Apache 2 sounds daring. What platform are you on? If you can track down more information, file a bug at http://bugs.php.net/. Also see http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Multiple Oracle connections
Hi, I am hoping that someone can help diagnose this issue. I am able to successfully connect to and query a remote Oracle 9.2 database from apache2/php5. However, when I have multiple clients hitting my php scripts, all of which require a connection to the database, problems begin to occur. The first script running gets a connection to the database, start performing queries, etc. While the first connection is running all other pages hang while trying to connect to the database until the first page finishes. I have tried all of the following to no avail: oci_connect, oci_new_connect, and oci_pconnect. The results are always the same, only one connection opens, all others end up waiting. I have found that I can connect to the DB through other methods at the same time (jdbc, sqlplus). Is it possible I have configured something incorrectly or I have the wrong expectations? I could not find anything on the web concerning this issue and I know there must be much higher traffic installations that would have experienced this issue if it was widespread. Any help would be greatly appreciated. -Chris Back -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php