This content has been marked as final. Show 11 replies
still oracle process consuming more than 90% of RAMCan you share how did you calculate memory taken by Oracle ?
Are you missing cache??
Check Mos Notes :
Oracle Background Processes Memory Consumption [ID 77547.1]
monitor V$PROCESS to see which process is responsible.
Check this out and see if it helps :
Oracle process memory usage
Thanks for the posts.. Will check and revert.
It would be better if you can tell us how you are coming to the conclusion that the RAM is 100% consumed? As 11g has mentioned, there may be cached portion of RAM which you would need to take into account.
Hi Aman Sir,
I will explain with an example :
total ram : 32 GB
SGA : 12 GB
PGA : 6 GB
Now I am checking the stats from 'prstat -a' and what i see is that the orauser consume all the memory of the server:
For now we see the orauser is taking 79% of the memory. Should it not just use the SGA allocated to it ?
NPROC USERNAME SWAP RSS MEMORY TIME CPU 1029 orauser 36G 25G 79% 126:35:18 40%
Top command is not working on this server.
We also checked from Grid and found that all the memory was getting consumed from this user..
And can you please tell me what is 'cache' concept in 11g.
Solaris does not accurately report process RAM consumption for Oracle process that utilize Shared Memory
How many instances and how many Oracle server processes?
If you do have 1029 processes, I'd expect at least a gig or two of memory consumed in addition to SGA and PGA. The latter may also be larger than target, maybe more probably so with many processes (at least "some" space for session etc. is required).
can you post the values for following parameters..
sql>show parameter memory
We did a 2 node migration for this setup and the problem looks to be resolved. Hence closing/ thanks all.