Oracle啟動時提示map size mismatch; abort

  今天在DELL服務(wù)器的Redhat 6.4上安裝Oracle10.2.0.4,用sqlplus 登陸數(shù)據(jù)庫，會出現(xiàn)如下的提示：

map size mismatch; abort: Success，不過其他的功能都正常，只是有這個提示

解決方法：

alter system set "_enable_NUMA_optimization"= false scope=spfile;

alter system set "_db_block_numa"=1 scope=spfile;

SQL>shutdown immediate

SQL>startup

col name for a40

col value for a40

col describ for a40

set linesize 130

NUMA是CPU的一種技術(shù)，開啟需要硬件的支持，關(guān)于這兩個參數(shù)的解釋：

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ

FROM SYS.x$ksppi x, SYS.x$ksppcv y

WHERE x.inst_id = USERENV ('Instance')

AND y.inst_id = USERENV ('Instance')

AND x.indx = y.indx

AND upper(x.ksppinm) like '%NUMA%';

NAME  VALUE   DESCRIB

---------------------------------------- ---------------------------------------- ----------------------------------------

_rm_numa_sched_enable  FALSE   Is Resource Manager (RM) related NUMA sc

  heduled policy enabled

_NUMA_pool_size   Not specified   aggregate size in bytes of NUMA pool

_enable_NUMA_optimization  TRUE   Enable NUMA specific optimizations

_NUMA_instance_mapping  Not specified   Set of nodes that this instance should r

  un on

_rm_numa_simulation_pgs   0   number of PGs for numa simulation in res

  ource manager

NAME  VALUE   DESCRIB

---------------------------------------- ---------------------------------------- ----------------------------------------

_rm_numa_simulation_cpus  0   number of cpus per PG for numa simulatio

  n in resource manager

_db_block_numa  2   Number of NUMA nodes

7 rows selected.