Home » RDBMS Server » Server Administration » Background process consuming high memory
Background process consuming high memory [message #223844] Mon, 12 March 2007 01:21
Messages: 1
Registered: March 2007
Location: Hyderbad
Junior Member
Hi All,

Currently we are Using Oracle db version on Solaris (RAM is of 4GB), We are using an SGA size of 2000MB(approx).

Problem is when i checked the memory consumption using
prstat -a , it's displaying that the memory consumption by
oracle user it self is consuming all the memory(100%)

When I checked the process(using PID's) which are consuming the highest memory, i am shocked to find that the each individual oracle Background process( smon, pmon, dbwr,lgwr, ckpt, arch ) is consuming some 2085MB(approx) of memory.

I thought the problem may be due to Oracle Version, and upgraded from to, but it's of no use. The same problem is continuing.

I am not able to find the cause for this, please help me in
solving the problem.

Previous Topic: problem with password file
Next Topic: create tablepace
Goto Forum:

Current Time: Tue Jul 25 20:17:47 CDT 2017

Total time taken to generate the page: 0.13947 seconds