Re: [PHP-DB] Multiple Oracle connections

2004-10-04 Thread Bastien Koert
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

2004-10-03 Thread Christopher Jones

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

2004-09-22 Thread Chris Back
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