Shulou(Shulou.com)06/01 Report--

Today, when you install Oracle10.2.0.4 on Redhat 6.4 of the DELL server and log in to the database with sqlplus, the following prompt will appear:

Map size mismatch; abort: Success, but all other functions are normal, except for this hint

Solution:

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 is a technology of CPU. Hardware support is required to enable it. Explain these two parameters:

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.