Home » Other » General » memory high (no of httpd connections increase) (Oracle Application , 9.0.1.4.0,HP-UX 11.11)
memory high (no of httpd connections increase) [message #453787] Sat, 01 May 2010 02:21 Go to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hi,

The Application server backup with 9.0.1.4.0 on HP-UX platform facing acute memory high (100%) usage, As i noticed nothing has been change since two weeks.

This problem started from last two days, I noticed the "http(ps -ef |grep httpd |wc -l" output increase unexpectedly.

After reaching 100%memory the users unable to connect application & database.

Even after restarting opmnctl the httpd process did not decrease.

#My concern issue httpd is fi9 or this is its normal behaviour
#Iam planning to change dbc_max_pct from 50 to 20 does this workout.

I appreciate expert views upon this issue.

Regard's
Re: memory high (no of httpd connections increase) [message #453792 is a reply to message #453787] Sat, 01 May 2010 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Kill the process but if nothing has changed then nothing has changed including cpu consumption, so if cpu consumption has changed then something has changed.

Regards
Michel

[Updated on: Sat, 01 May 2010 03:03]

Report message to a moderator

Re: memory high (no of httpd connections increase) [message #453793 is a reply to message #453792] Sat, 01 May 2010 05:09 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hello Michel,

After killing the "http" user connection process the memory reduced 2% and again increased drastically.

High memory effects during 'http' user connection process.

Regard's
Re: memory high (no of httpd connections increase) [message #453839 is a reply to message #453793] Sun, 02 May 2010 04:44 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hello Michel,

Is there anything to be set in Apache.conf or httpd.conf may be due to users increase the httpd sessions also increase which consumes more memory.


Regard's
Re: memory high (no of httpd connections increase) [message #453842 is a reply to message #453839] Sun, 02 May 2010 04:51 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I'm not an Apache guy, only a rdbms one with basic knowledge in other domains.

Regrads
Michel
Re: memory high (no of httpd connections increase) [message #453843 is a reply to message #453842] Sun, 02 May 2010 05:16 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Thanks ............
Re: memory high (no of httpd connections increase) [message #453933 is a reply to message #453843] Mon, 03 May 2010 02:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yea. Had this problem some years ago. The AS starts two processes for every user but only gets rid of one of them when the user is finished. Our AS engineer 'NOP'ed the call that started the second (or was it first?) process and after that we had no more problems. Unfortunately, that means ZAPing Oracle's executable code which is, of course, not supported by Oracle.

David
Re: memory high (no of httpd connections increase) [message #455517 is a reply to message #453933] Wed, 12 May 2010 00:51 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
hmmm So, How to sort it out with Oracle support open options. ....

Thanks & Rgd's
Re: memory high (no of httpd connections increase) [message #455545 is a reply to message #455517] Wed, 12 May 2010 01:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Would you please supply a link to "Oracle support open options".

David
Previous Topic: Data Inventory of all tables in a database
Next Topic: Difference between OLTP & DataWarehouse
Goto Forum:
  


Current Time: Fri Apr 18 18:54:52 CDT 2014

Total time taken to generate the page: 0.09816 seconds