Re: SGA in memory

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 16 Mar 1999 15:12:52 GMT
Message-ID: <7clsda$814$1@nnrp1.dejanews.com>

In article <01be6f6a$f25bedc0$6b3574cb_at_taykg>, "Tay Khoon Guan" <taykg_at_cse.com.sg> wrote:
> Hi,
>
> How will I know if my SGA is in the main memory but not in the swap space
> so that I can tune the sga to fit into the memory.
>
> Is there any ways to pin my sga to the memory?
>
> Thanks.
>

On different platforms there were different names for this parameter. Names were like mpin_sga,mlock_sga,lock_sga or something like that. On most newer versions this parameter no longer exists. Even if you do have it, please don't use it. The other way of achieving the same thing would be to write a small program that would attach SGA as root (see ipcs) and lock it via mlock system service. But we are talking dangerous sorcery now. Please consult Oracle before attempting to do anything like that.

Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 16 1999 - 09:12:52 CST