OCINLogon/OCILogoff leaves open sessions
| From: | php at home dot uh dot nu | Date: | Thu, 02 Mar 2000 02:28:35 +0000 |
| Subject: | OCINLogon/OCILogoff leaves open sessions | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-11305@lists.php.net to get a copy of this message | ||
Howdy,
I'm doing some testing with the latest cvs of php4 and have found an icky
problem with sessions being left open in oracle.
The script below is my source I'm using to create the problem.
It seems that it calling OCILogOff doesn't clean up oracle sessions
in the database. So if I run this script 250 times I eventually run out
of available sessions and have to restart oracle. I'm running in apache on
a linux box, and my oracle instance is over the network on a solaris box
running 8.0.5
<html>
<?
$connection = OCINLogon("user","passwd","db");
echo "connection = $connection<br>\n";
OCILogOff($connection);
?>
Hello World.
To continue, <A HREF="test.php">click here</A><br>
</html>
Walt