Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Memory usage 99% Oracle process

3018205Jan 5 2016 — edited Jan 7 2016

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.

This post has been answered by Stefan Abraham on Jan 5 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2016
Added on Jan 5 2016
7 comments
2,371 views