Search This Blog

2010-11-17

Oracle RAC Database Not Using HugePage

There is a known bug in Oracle 11g (fixed in 11.2.0.1 PSU 2, and 11.2.0.2 onward) which Oracle RAC database that starts with svrctl command won't make use of HugePage, and will get into swap space in Linux

One work around is as follow

File: /etc/init.d.ohash or /sbin/init.d/ohasd

Looks for similar line and replace with following
start()
{
$ECHO -n $"Starting $PROG: "
ulimit -n 131072 # Or higher
ulimit -l 50000000 # Or higher
}

Related link (needs Oracle Metalink support contract and login)
https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=9251136
Bug 9251136: INSTANCE WILL NOT USE HUGEPAGE IF STARTED BY SRVCTL

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=983715.1
11gR2 Grid Infrastructure Does not Use ULIMIT Setting Appropriately [ID 983715.1]

Please use following PayPal donate if my post helped

No comments: