[PHP-DB] help with multiple oracle connections From: Doug Farmer (daf <email protected>)
Date: 08/30/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>