Solved

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

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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…

746 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now