i don t really need to keep reconnecting. i made this script to reproduce problem with apache. ie:apache's child keep a lot of Fd to ocius.msg . -----Message d'origine----- De : Christopher Jones [mailto:christopher.jones@xxxxxxxxxx] Envoye : vendredi 13 aout 2004 15:12 A : yannick Cc : php-db@xxxxxxxxxxxxx Objet : Re: OCI8 It might be a feature of PHP's connection caching. Why don't you log a bug in the PHP bug DB so the problem can be tracked? Do you really need to keep reconnecting? See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq .html#conmgt Chris yannick wrote: > I have some trouble with Oracle Database and php... > > see this code: > <? > while (1) { > $conn=OCILogon($username,$password,$database); > $stmt=OCIParse($conn,"select 50 as toto from dual"); > OCIDefineByName($stmt,"TOTO",&$total); > OCIExecute($stmt); > OCIFetch($stmt); > echo ":::$total:::\n"; > OCILogoff($conn); > $err=OCIError($conn); > OCILogoff($conn); > sleep(10); > } > ?> > > when i execute it, the number of fd on ocius.msg is growing. but there is > only 1 connection at database. > > Can someone help me ? > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php