help with multiple oracle connections

From: Date: Wed, 30 Aug 2000 18:59:42 +0000
Subject: help with multiple oracle connections
Groups: php.db 
Request: Send a blank email to php-db+get-2494@lists.php.net to get a copy of this message
I'm attempting to connect to 2 different databases within the same page. The operations succeed but...when I look at the number of oracle dedicated server processes on the second database, they are being maintained and not closed all the time (in some cases, they are). They all go away when we restart the apache server. The number of oracle dedicated server processes continually creep up until we have to restart the web servers because we run out of file descriptors. We have determined that this behavior does not occur if you separate the calls into 2 separate pages. Here is my pseudocode that illustrates what I am trying to do. The ORA_* patterns are defines elsewhere in the code. if ($conn = OCILogon( ORA_USER, ORA_PASSWORD, ORA_DB1)) { // OCBindByNames and OCIExecute OCIFreeStatement ($stmt); OCILogoff($conn) } if ($conn = OCILogon( ORA_USER2, ORA_PASSWORD2, ORA_DB2)) { // OCBindByNames and OCIExecute OCIFreeStatement ($stmt); OCILogoff($conn) } I'm using php 3.0.14, apache 1.3.9, and oracle 8.1.6 client on linux to oracle on solaris. Thanks for your help. - doug

« previous php.db (#2494) next »