Re: locking Oracle SGA into RS/6000 memory

From: Mohamed El-Mallah <mie_at_sddpc.sannet.gov>
Date: 1997/04/11
Message-ID: <5imats$7ti$1@dpcgate.sannet.gov>#1/1

Hi,
Well u can try PRE_PAGE_SGA parameter, but as Oracle says "this settingdoes not prevent your operating system from paging or swapping the SGA after it is initially read into memory". Regards
Mohamed El-Mallah
San Diego DPC

"Adrian Shepherd" <Adrian.Shepherd_at_btinternet.com> writes: > Try the init.ora parameter PRE_PAGE_SGA
> Beware , the SGA should reside in memory anyway , if this is not teh case
> and the SGA is paged out then you probably have a severe RAM shortage - BMM
> !
>
> --
> Adrian J Shepherd
> Oracle Consultant
> Hash Consultancy Ltd.
>
> Lance Tost <ltost_at_systemautomation.com> wrote in article
> <860426695.11641_at_dejanews.com>...
> > We're just getting underway with Oracle 7.3 server under AIX 3.2.5
> > (probably soon to be 4.1) on an RS/6000. Can someone tell me (or point
me
> > to documentation which will tell me) how to lock the SGA into real
memory?
> > I've looked in the 7.3 Administrators Reference for AIX as well as the
> > tuning tips manual-- can't find any mention of it.
> >
> > email ltost_at_systemautomation.com with any info.
> > Thanks.
> >
> > -------------------==== Posted via Deja News ====-----------------------
> > http://www.dejanews.com/ Search, Read, Post to Usenet
> >
Received on Fri Apr 11 1997 - 00:00:00 CDT