Multiple Oracle connections
| From: | Chris Back | Date: | Wed, 22 Sep 2004 13:14:42 +0000 |
| Subject: | Multiple Oracle connections | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36327@lists.php.net to get a copy of this message | ||
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