Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199807

Re: [PHP3] READ: Why is Oracle hanging? From: Asian Avenue (ccimail <email protected>)
Date: 07/23/98

Rasmus, I have used the code you posted in that mail.....same results.
We never have this problem under moderate load.....under heavy load,
though, the damn thing is gone. Right now I have 195 SLEEPING processes
and ONE running.....it is the top session I am running to gather this
information. Looking at the Oracle database machine....there are 215
processes......all sleeping except top.

I have the same setup......Oracle 8.0.3....Solaris 2.6. This is a pretty
serious problem for us.....we may have to rollout of PHP 3.0 and
re-rewrite everything for PHP 2.....we know this does not exist in PHP 2.
We really want to avoid this.

Are there ANY further suggestions or ideas?

Mike

-=> Get your FREE Internet E-mail account now at
     http://www.CommunityConnect.com

Michael C. Montero
Vice President of Technology
Community Connect Co-founder
Asian Avenue Member
Mike <email protected>

-=-=-=-=-= Community Connect Inc. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

The Premier Source of Interactive Online Communities 25 Broad Street
http://www.CommunityConnect.com New York, NY 10004

http://www.AsianAvenue.com
        The Interactive Online Community for Those of Asian Heritage

----- Your Message May Appear Below This Line

On Thu, 23 Jul 1998, Rasmus Lerdorf wrote:

> > I posted an early question entitled "Random PHP Errors", which no one seemed to
> > have read, but oh well. We are having the same problem, with the exception of
> > Apache 1.2.6 I believe. After running our programs, we end up
> > with multiple connectoins to the Oracle database, sometimes up to 8 for one
> > person, as if PHP was negotiating persistent connections when it shouldn't be.
> > This also caused major slowdown in performance after running it for some time.
> > One thing we did notice was we were getting constant "Bad Free() Ignored" from
> > Apache, which we believe to be a memory leak causing these errors to occur with
> > Oracle and performance. This is a serious problem, so anyone out there with
> > some suggestions, I would greatly appreciate it.
>
> I helped set up a production service running Oracle8 on Solaris 2.5.1 with
> PHP 3.0 and Apache 1.3.0. Stress tested under heavy loads and haven't had
> any similar problems. How are you establishing your connections?
>
> Have a look at this post I wrote a couple of days ago:
>
> http://www.progressive-comp.com/Lists/?m=90108820526929&w=2
>
> -Rasmus
>
>
> --
> PHP 3 Mailing List http://www.php.net/
> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest list: php3-digest-subscribe <email protected>
> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3
>
> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3