Re: Help: Hundreds of connections PHP->Oracle

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 16 Feb 2006 02:16:54 GMT
Message-Id: <pan.2006.02.16.02.16.52.894202@sbcglobal.net>

On Wed, 15 Feb 2006 07:44:19 -0800, jonathan.beckett wrote:

> I've seen something about this in the past but can't remember exactly
> why it happened (Oracle not closing connections).

It's persistent connections problem. I believe that this was resolved in 5.1.2, not before. The problem is that whenever one uses oci_pconnect, httpd process opens session. For some reason, when a new HTTP request is issued, new httpd process is created and logged into the database. When the number of httpd threads is high enough, "sessions" parameter is exhausted and nobody can connect any more. There are nuances, I believe that the problem only manifests itself with shared servers or something like that. If you need it for the commercial use, I wholeheartedly recommend Zend Core for Oracle. It's beautiful and most of the OCI bugs are fixed.

-- 
http://www.mgogala.com

Received on Wed Feb 15 2006 - 20:16:54 CST