Re: memory related problems
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 18 Feb 2010 09:53:44 -0800 (PST)
Message-ID: <643091.41137.qm_at_web80606.mail.mud.yahoo.com>
> sga_max_size24G
> sga_target 24G
> pre_page_sgaTRUE
...
> vm.nr_hugepages = 12293
>
> --limits.conf
> oracle hard memlock 25176064
> oracle soft memlock 25176064
Date: Thu, 18 Feb 2010 09:53:44 -0800 (PST)
Message-ID: <643091.41137.qm_at_web80606.mail.mud.yahoo.com>
> sga_max_size24G
> sga_target 24G
> pre_page_sgaTRUE
...
> vm.nr_hugepages = 12293
>
> --limits.conf
> oracle hard memlock 25176064
> oracle soft memlock 25176064
Your SGA, memlock and hugepage size are too close to each other. For reason I don't know, sometimes hugepages have to be a little larger than SGA. In any case, memlock can be set to very large with no harm. It doesn't actually allocate memory as hugepages does.
When you start using srvctl and have a lot of swapping, is HugePages used? Check /proc/meminfo. You probably get out of memory error in $ORACLE_HOME/log/<host>/racg/imon_<db>.log.
You don't another instance on this box including ASM, do you?
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 18 2010 - 11:53:44 CST