You are here: Re: Help: Hundreds of connections PHP->Oracle « PHP Programming Language « IT news, forums, messages
Re: Help: Hundreds of connections PHP->Oracle

Posted by Keith E. Sauvant on 02/16/06 10:39

Mladen Gogala schrieb:
> On Wed, 15 Feb 2006 15:31:27 +0100, Keith E. Sauvant wrote:
>
>> Does it make any difference if oracle is installed locally or on
>> another machine? Is it relevant if we connect to the database using
>> a service_name or a SID?
>>
>> Any comments, hints, help?
>
> You are probably using persistent connections?

Yes, we do. Means: we were ;-) I tried without persistent connections
yesterday and it had far more comprehensible behaviour. Still waiting
for the customer test results.

> 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.

But: In our case it is ONE PROCESS that starts opening connections. We
start a script that runs for some hours. It runs fine for one hour and
then it starts opening additional connections to the database. Strange
behaviour.

> 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.

I like the idea of using Zend Core for Oracle. But: PHP5 is still not
certified for some of our customers.

We use the latest PECL OCI8-Extension. That should be exactly the one
Zend Core uses. Am I right?

Best regards
Keith

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация