From: jreesmf@mac.com (Joel Rees) Newsgroups: comp.databases.oracle.server,comp.databases.oracle,comp.database.oracle Subject: Re: web app gets max processes about every three months Date: 8 Aug 2002 02:42:45 -0700 Organization: http://groups.google.com/ Lines: 38 Message-ID: References: NNTP-Posting-Host: 61.114.244.165 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1028799765 10856 127.0.0.1 (8 Aug 2002 09:42:45 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2002 09:42:45 GMT "T. Schmidt" wrote in message news:... > # 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" wrote in message > news:f0d5086.0208050239.31d4911b@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.