Is NUMA Enabled?
The following query was posted on helpkern as a way to determine whether NUMA is enabled:
select distinct proc_group from x$kcbwds;
If more than one row is returned then NUMA is enabled.
By default NUMA (Non Uniform Memory Access) is turned on in 10.2. It is disabled by default under 10.2.0.5 and 11.2.
从10.2.0.5开始 numa就默认关闭了 。 我的理解是 oracle vos 开发组认为Numa在实际广泛测试后并没带来多大好处,还引入了其他问题。 所以干脆默认不开了。