Re: Memory on Unix - ORACLE SGA

From: Steve Phelan <stevep_at_no-spam.pmcgettigan.demon.co.uk>
Date: 1997/07/03
Message-ID: <33BB5487.731099B4@no-spam.pmcgettigan.demon.co.uk>#1/1

Helen Vanderheide wrote:

> 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?

A word of advice: Don't believe that locking the SGA in memory to the detrement of everything else on your system will improve performance. Tread carefully...

Steve Phelan. Received on Thu Jul 03 1997 - 00:00:00 CDT