We have some ORACLE PGA problem and ORACLE document say we can serup lockmem(Max lock memory) to higher value.
$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 set lockedmem to higher value on CENTOS 5.4?
Thanks.
mcclnx mcc wrote:
We have some ORACLE PGA problem and ORACLE document say we can serup lockmem(Max lock memory) to higher value.
$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 set lockedmem to higher value on CENTOS 5.4?
Thanks.
did you try man ulimit? it shows ulimit -l [limit]
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
mcclnx mcc wrote:
We have some ORACLE PGA problem and ORACLE document say we can serup lockmem(Max lock memory) to higher value.
<snip>
Can anyone tell me how to set lockedmem to higher value on CENTOS 5.4?
Have you considered googling before posting? Say, with the search terms being linux lockedmem ? Lessee, the eigth hit I get is:
http://linuxtechres.blogspot.com/2009/10/setting-up-64bit-oracle-11gr1-on-64bit.html
mark, rtfm, too