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_

These params may need some settings.

That you can see by using the following SQL:

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

No comments:

Post a Comment