From: "Victor L. Artchakov" <victor@rias.khv.ru>
Subject: Re: Memory on Unix - ORACLE SGA
Date: 1997/07/03
Message-ID: <AAirvVtaz9@rias.khv.ru>#1/1
Distribution: world
Sender: news-service@news.redcom.ru
References: <5peccg$4jq@priv-sys04-le0.agt.net>
Organization: unknown
Reply-To: victor@rias.khv.ru
Newsgroups: comp.databases.oracle.server
X-Return-Path: victor@rias.khv.ru



Hi,
Use vmstat or sar commands.
Your goal is to minimize swap-outs as mach as possible.

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