Hello,
I work on a linux server:
Red Hat Enterprise Linux Server release 5.7 Beta (Tikanga).
This server contain several instances all using the same Oracle home :
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
A few days ago I add 15GB of memory for a total of 70GB of memory and 40GB of swap.
But the memory usage still always at 99% when I use ‘top’ command:
Cpu(s): 0.3%us, 0.3%sy, 0.0%ni, 99.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 70947372k total, 70599172k used, 348200k free, 559640k buffers
Swap: 41945704k total, 191308k used, 41054396k free, 62598884k cached
And when I check the process using most memory I got this list :
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21948 oracle 15 0 9483m 6.0g 6.0g S 0.0 8.9 0:52.53 oracle
21952 oracle 15 0 9512m 5.6g 5.6g S 0.0 8.3 8:55.01 oracle
21956 oracle 15 0 9512m 5.6g 5.6g S 0.0 8.3 9:05.64 oracle
10675 oracle 15 0 5678m 3.4g 3.4g S 0.0 5.0 2:46.15 oracle
10679 oracle 15 0 5670m 3.4g 3.4g S 0.0 5.0 2:53.15 oracle
21968 oracle 15 0 9493m 3.0g 3.0g S 2.3 4.5 2:57.26 oracle
The process with PID 21948 (using 6GB of memory) Is :
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 21948 0.0 8.9 9710892 6336604 ? Ss 2015 0:52 ora_mman_ORACLE_SID
and the second process on the list (PID 21952) is :
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 21952 0.0 8.3 9740328 5909300 ? Ss 2015 8:55 ora_dbw0_ ORACLE_SID
these 2 process are on the same ORACLE_SID.
My question in is this a normal situation? And if not, how can I reduce the memory usage on this ORACLE_SID?
Thank in advance for your help
Regards
btw: I am sorry for my bad english.