PHP and Oracle Zombie processes

From: Date: Wed, 14 Mar 2001 04:25:10 +0000
Subject: PHP and Oracle Zombie processes
Groups: php.general 
Request: Send a blank email to php-general+get-43745@lists.php.net to get a copy of this message
When I execute an sql statement against my Oracle database from PHP, I create an oracle <zombie> process. This eventually hits a "number of zombie process" limit and prevents my page from executing. The queries work properly (except for the zombie problem). Here is a sample that creates the zombie process: putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6"); putenv("ORACLE_SID=dbase_name"); putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin"); // thought this might help the zombie problem $conn=OCILogon("get_rid_of" , "zombie"); $sql_get_info="SELECT OppID, OppTitle FROM TEST WHERE OppID=4"; $stmt = OCIParse($conn,$sql_get_info); OCIExecute($stmt); OCIFetch($stmt)); $valid_opp_id = OCIResult($stmt, "OPPID"); $valid_opp_title = OCIResult($stmt, "OPPTITLE"); OCIFreeStatement($stmt); ///// using a separate query to get the clob...... $clob_field="OPPTEXT"; // this field in UPPPER CASE $sql="SELECT $clob_field from TEST WHERE OppID=$oid"; $stmt = OCIParse($conn, $sql); $clob_text = OCINewDescriptor($conn,OCI_D_LOB); OCIDefineByName($stmt, $clob_field, &$clob_text); OCIExecute($stmt); OCIFetch($stmt); $valid_text=$clob_text->load(); $clob_text->free(); OCIFreeStatement($stmt); Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) : ./configure --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/etc/httpd --with-oracle=/ora8/m01/app/oracle/product/8.1.6 I also added OCI8 support via.. --with-oci8=/ora8/m01/app/oracle/product/8.1.6 ... phpinfo(); states oci8 support is "enabled". I did --enable-sigchild but I don't see it showing in the phpinfo(); ??? I am using: Oracle 8.1.6, Apache 1.3.12 , RedHat 6.0 - all on one server. Any ideas on what I might be doing wrong? Am I missing something? Any help would be greatly appreciated. Thanks, Bob

« previous php.general (#43745) next »