How to enable NUMA on 10G @ linux

參見

Oracle RDBMS is not detecting NUMA Nodes [ID 868642.1]

當然首先保證平臺支援：

[root@xxx bin]# numactl --hardware
available: 2 nodes (0-1)

 

其實就是建立如下軟連線：

cd /usr/lib64
ln -s libnuma.so.1 libnuma.so
cd /usr/lib
ln -s libnuma.so.1 libnuma.so

在初始化檔案里加入：

_enable_NUMA_optimization=TRUE

 

最後重啟資料庫時在alert.log裡可以看到：

> grep -i numa *.log
NUMA system found and support enabled (2 domains - 12,12)
  _enable_NUMA_optimization= TRUE
Opening with internal Resource Manager plan : on 2 X 12 NUMA system

這個引數不再是1了：

_db_block_numa                                2                    Number of NUMA nodes