Solved

top output total sum of oracle processes RAM usage is more than actual physical RAM

Posted on 2009-07-02
2
488 Views
Last Modified: 2013-12-19
redhat enterprise linux 4 U 4
two servers, each has 4GB RAM, shared storage, cluster oracle 10g rac database
when I look at top command output and sums up all the oracle processes RAM usage (i.e. the RES top field) the result is more then the actual physical RAM
this phenomena is on both servers
how can it be axplained ? how can I monitor the real RAM usage of oracle processes ?
Thnaks allot in advanced
0
Comment
Question by:eranpsh
2 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24764023
This is normal.

Oracle's SGA uses shared memory and is reported in each process size. The SGA is common to all Oracle server processes so for example a 1GB SGA x 8 processes will appear to be used 7GB more RAM than it really is.

Use ipcs command to see the segments
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see …
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question