Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SGA and pinned

Re: Dynamic SGA and pinned

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Thu, 5 Aug 2004 20:24:51 +0100
Message-ID: <5PhSp4ADmoEBRxxy@peterfinnigan.demon.co.uk>


>unless, as the OP pointed out, the SGA is locked in phys memory, which
>would prevent the virtual memory subsystem from paging it out. You can
>use the lock_sga parameter to control this. (false by default, which
>would allow paging out the SGA)
>
>quote from the 9.2 manuals:
>>>
>LOCK_SGA locks the entire SGA into physical memory. It is usually
>advisable to lock the SGA into real (physical) memory, especially if
>the use of virtual memory would include storing some of the SGA using
>disk space. This parameter is ignored on platforms that do not support
>it.
><<

Hi Karsten,

Just as an aside to this discussion...:-)

You cannot simply set this parameter on Solaris as only root can generally lock shared memory segments and the Oracle software generally doesn't run as root. Indeed its not a good idea to run Oracle as root!. You can grant access to shared memory segments to other users, but i cannot remember the exact syntax. There is another way to do it using a simple C program to lock the shared memory. I posted a program a while ago to this list. I added a copy of my post to my site, its at http://www.petefinnigan.com/ramblings/lock_sga.htm if anyone is interested.

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
Received on Thu Aug 05 2004 - 14:24:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US