I have defined 40% SGA of my RAM ,20% PGA still oracle process consuming more than 90% of RAM . Can some one help me to understand why it is happening.
DB version -: 22.214.171.124
OS version - : solaris sparc 10
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:
NPROC USERNAME SWAP RSS MEMORY TIME CPU
1029 orauser 36G 25G 79% 126:35:18 40%
For now we see the orauser is taking 79% of the memory. Should it not just use the SGA allocated to it ?
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.
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).