Tuesday, March 24, 2009

HIDDEN INIT.ORA Parameters : _NUMA_ related

NUMA: Non Uniform Memory Access

There are some NUMA params, which are hidden, as below:

=>cat HIDDEN_PARAMS_ORA10g.lst | grep _NUMA_
_NUMA_pool_size
_enable_NUMA_optimization
_NUMA_instance_mapping


These params may need some settings.

That you can see by using the following SQL:


SELECT
a.ksppinm "Parameter",
a.ksppdesc "Description",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE
a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/_%' escape '/'

No comments:

Post a Comment