setup lockedmem (max lock memory)???

[dba1 mcc]

We have some PGA issue and I saw ORACLE document say we can set Max lock memory (lockedmem) to higher number.

$ulimit -a

time(cpu-seconds) unlimited
file(blocks) unlimited
coredump(blocks) 0
data(kbytes) unlimited
stack(kbytes) 10240
lockedmem(kbytes) 3145728
memory(kbytes) unlimited
nofiles(descriptors) 65536
processes 2047

can anyone tell me how to do it on Redhat 5.4? Thanks.




--
http://www.freelists.org/webpage/oracle-l

[Yong Huang]

Just add memlock to this file:

$ grep memlock /etc/security/limits.conf
# - memlock - max locked-in-memory address space (KB)
oracle soft memlock 8590000
oracle hard memlock 8590000

But if you use srvctl in 11g and want to use HugePages, due to Bug 9251136 (INSTANCE WILL NOT USE HUGEPAGE IF STARTED BY SRVCTL), you also need to add ulimit -l <number> to either $GRID_HOME/bin/ohasd or /etc/init.d/ohasd.

You can check the limit of a running process with command:
grep "Max locked memory" /proc/<pid>/limits'

Yong Huang

Post by dba1 mcc
We have some PGA issue and I saw ORACLE document say we can set Max lock
memory (lockedmem) to higher number.
$ulimit -a
...
lockedmem(kbytes) 3145728
...
can anyone tell me how to do it on Redhat 5.4? Thanks.

--
http://www.freelists.org/webpage/oracle-l