Re: how do I determine if SAG stays in main memory

John Bechtel wrote:
>
> Bob Yeh wrote:
> >
> > Hi,
> >
> > Is there a way to guarantee that if SGA always stays in main memory and
> > how can I tell if SGA is swapped out?
> >
> > Server 7.3 running on SUN Solaris 2.4.
> >
> > Thanks.
> > Bob
>
> On some platforms, you can set _lock_sga = true which will allow SGA
> shared memory segments to be hard-locked into pyhsical memory. I know
> this works on Sequent and DG platforms, but I don't believe Sun supports
> it.

 <snip>
> John Bechtel
> DBA - TDS Computing Services

  The default on the platform you mention is that the init.ora parameter USE_ISM (intimate shared memory) is TRUE. One effect of this is that the SGA will not be paged out. Check and see if this is set to TRUE for you. Look at Adrian C.'s fine series of article at

     http://www.sun.com/sunworldonline

for much more detail on all Solaris memory and/or tuning issues.

-- 
	Scott Kelley (skelley_at_online.disney.com)
	Webmaster/Database Administrator for Disney Online

# THIS IS A DISCLAIMER: The above statements were written by Elves.
# The above is not the position or opinion of the Walt Disney Company.