Solved

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

Posted on 2009-07-02
2
485 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

776 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