Determine _enable_NUMA_optimization paramater value in Oracle 10g Enterprise Edition Release - 64bit

In an oracle instance running Oracle Enterprise edition  on Solaris, querying the v$system_parameter  indicates that this parameter is explicitly set to False - meaning that Numa optimization is not enabled.

In another  oracle  instance running Oracle Enterprise edition  on Solaris,  querying the v$system_parameter does not retutn any information for the _enable_NUMA_optimization  parameter - It is not in the result set of the 'select * from v$system_parameter' query.  How does oracle interpret/treat  this parameter in this scenario , and is there a default behaviour that kicks in?

Who is Participating?

Default value for 10g _enable_NUMA_optimization  is: true.

For details check metalink note 429872.1

You can use the following query to get the hidden parameters, describing NUMA state:

col "Parameter" for a50
col "Session Value" for a15
col "Instance Value" for a15
col "Description" for a100
select a.ksppinm  "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value",
  ksppdesc "Description"
  from x$ksppi a, x$ksppcv b, x$ksppsv c
 where a.indx = b.indx and a.indx = c.indx
   and substr(ksppinm,1,1)='_' 
   and lower(a.ksppinm) like '%numa%'
order by a.ksppinm;

Open in new window

One of the parameters listed is "_enable_NUMA_optimization".
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.