From: chrise@shore.net (Chris Eastland)
Subject: Re: Memory on Unix - ORACLE SGA
Date: 1997/07/07
Message-ID: <5pr298$jou@shell2.shore.net>#1/1
References: <5peccg$4jq@priv-sys04-le0.agt.net>
Organization: Chris Eastland
Newsgroups: comp.databases.oracle.server



Helen.Vanderheide@telus.com (Helen Vanderheide) writes:

>How do you know whether part of your SGA gets swapped or paged out of
>memory?
 
>I want to ensure that the whole SGA stays in memory all of the time.
> 
>When I do a:   ipcs -mb   I see that the active shared memory segment
>sizes owned by oracle is the same size as my SGA, so I am assuming
>that the whole SGA is in memory.  
 
>Can shared memory segments get swapped out?


Varies by platform but a rule of thumb is if you have free memory lots
of the time (use top to see), you're not swapped out (shared memory can
be swapped out on most platforms).