Re: locking Oracle SGA into RS/6000 memory

In article <01bc437e$55597e80$383c63c3_at_adrian>,   "Adrian Shepherd" <Adrian.Shepherd_at_btinternet.com> wrote:
>
> 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.
> >
> >

Pre-page-sga takes affect only at instance startup by reading the whole SGA into memory. It does not prevent the SGA from being paged out when the OS needs to swap.

Maybe you could try reducing the nice value of the Oracle server process which aquires the shared memory segment for allocating the SGA. In this way since the server process will never be paged out, the shared memory segment (SGA) will also never be paged out.

Let me know what you think of this. Wld appreciate knowing the the results if you do try this.

Rgds,
Noaman Mulla.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet