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

Currently we are Using Oracle db version 9.2.0.1 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 9.2.0.1 to 9.2.0.8, 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.

Regards,
Anwesh.
Previous Topic: problem with password file
Next Topic: create tablepace
Goto Forum:
  


Current Time: Mon Dec 05 06:34:11 CST 2016

Total time taken to generate the page: 0.08766 seconds