Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to LOCK_SGA on Solaris
Daniel Morgan wrote:
> Frank Langelage wrote:
>
>> Today I switched param LOCK_SGA from FALSE to TRUE. >> After this the restart of oracle failed: >> ORA-27126: unable to lock shared memory segment in core >> SVR4 Error: 1: Not owner >> >> If I change the owner of the oracle binary to root >> -rwsr-s--x 1 root dba 62723664 Dec 17 00:18 oracle >> then then startup succeeded. >> Processes are running with user=root (and realuser=oracle). >> >> Is there a way to use LOCK_SGA without changing owner to root ? >> >> Regards >> Frank
I want to achieve what the parameter does: lock the shm-segments in physical memory so that they aren't paged out to swapspace on disks when the system is short of memory.
I'm more familiar with informix so far. For informix setup locking the shm segment used for buffers in memory is very recommended. Received on Wed Dec 31 2003 - 09:05:29 CST