Posted by Mladen Gogala on 02/16/06 04:16

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

• Next in forum: Re: avoid object creation...
• Prev in forum: Re: Help: Hundreds of connections PHP->Oracle
• Thread view: Re: Help: Hundreds of connections PHP->Oracle

[Reply to this message]