Re: Memory on Unix - ORACLE SGA

From: Chris Eastland <chrise_at_shore.net>
Date: 1997/07/07
Message-ID: <5pr298$jou@shell2.shore.net>#1/1

Helen.Vanderheide_at_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). Received on Mon Jul 07 1997 - 00:00:00 CDT