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

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.

If you have a test database, you can try puting the parameter in the init.ora file and see if you can start the database. If you can't, just remove the line and startup again -- no harm done.

Make certain you have more than enough memory available on your system before you attempt this. If you run into a memory shortage crises for whatever reason, this memory will not be swapped or paged out to help relieve the problem and could possibly cause your system to hang/crash.

Good luck.

John Bechtel
DBA - TDS Computing Services Received on Wed May 07 1997 - 00:00:00 CDT