We have the same thing on are sites with:
PHP4.0.3pl1/Linux and Solaris/Oracle 8i
The DBA's were quite upset that the connections were never dropped by Apache because of PHP. This is a pain for DBA's since open connections prevent them from doing certian tasks like backups or shutdowns of the server. We changed to OCILogon and were unable to see a preformance drop. The DBA told us that *nix is very fast with TCP so persistant connections don't add that much. One way to work around this if you still want to use OCIPLogon is to set a MaxRequestsPerChild in httpd.conf this will cause the apache processes to only live for so many requests and die which will releae the connections. This will still not release all the connections but will eliminate connections staying open for days on end.
-Kevin
Richard Yaker wrote:
PHP not cleaning up connections.
PHP4.0/Apache/Oracle 8i/va-linux 6.2
I'm using PHP's OCIPLogon, which uses a connection pool to share already established connections. It works as expected, except PHP/Apache does not seem to let go of established db connections until Apache is stopped and restarted.
