Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: web app gets max processes about every three months

Re: web app gets max processes about every three months

From: Joel Rees <jreesmf_at_mac.com>
Date: 8 Aug 2002 02:42:45 -0700
Message-ID: <f0d5086.0208080142.1d574c54@posting.google.com>


"T. Schmidt" <t.schmidt_at_rmv.spm.semantica.nl> wrote in message news:<aiqq3l$8f0$1_at_reader09.wxs.nl>...
> # MaxRequestsPerChild: the number of requests each child process is
> # allowed to process before the child dies. The child will exit so
> # as to avoid problems after prolonged use when Apache (and maybe the
> # libraries it uses) leak memory or other resources.

Yeah, this is usually for memory leaks, but it might help with process allocation "leaks" as well.

> You could try to set the "MaxRequestsPerChild" parameter (httpd.conf) to eg.
> 1000.
>
> In conjunction with:
> KeepAlive
> MaxKeepAliveRequest
> KeepAliveTimeout
> MinSpareServers
> MaxSpareServers
> MaxClients
>
> Intensive tuning with these parameters solved our similar (??)
> Apache<->Oracle- processes problems.

Thanks for the suggestions. Question -- was your OS MSWindows? Also, what versions of the OS, Apache, and Oracle were you using?

Joel

> "Joel Rees" <jreesmf_at_mac.com> wrote in message
> news:f0d5086.0208050239.31d4911b_at_posting.google.com...
> > Wrote a question about this about six weeks back, still looking for
> > answers.
> >
> > We have a web app, Oracle on a dedicated machine, php and apache on a
> > separate machine, and three times in the past eight months, our php
> > logs tell us that oracle has got maximum processes allocated, and it
> > stays there until the customer resets the Oracle server. Host system
> > on each machine is MSW2k.
Received on Thu Aug 08 2002 - 04:42:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US