My Oracle Support Banner

Enable Oracle NUMA support with Oracle Server Version 11gR2 (Doc ID 864633.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Oracle on NUMA capable hardware

Details

Oracle NUMA (Non Uniform Memory Architecture) support can be used with large SMP multiprocessor environments with NUMA hardware. When enabled Oracle NUMA support facilitates efficient use of underlying NUMA hardware and may improve database performance.

Oracle NUMA support needs the right combination of hardware, operating system and Oracle version.

Starting with 11.2.0.1, Oracle NUMA support is disabled by default.

This note covers how Oracle NUMA support can be enabled via configuration for Oracle Server Version 11.2.

For more information about Oracle NUMA usage recommendation and Oracle NUMA support in previous releases please consult <Note:759565.1>

Care should be taken before enabling NUMA support. Contact your hardware vendor for recommendation and information on your system and operating system NUMA capabilities

Recommendation:

To enable NUMA support with Oracle Server Version 11gR2 consult the following section "Steps to enable NUMA with Oracle Server Version 11.2”. To disable NUMA on previous versions review <Note 759565.1>

Actions

Steps to enable NUMA with Oracle Server Version 11.2:

When running an Oracle database Version 11.2 in a NUMA capable environment, Oracle will not by default detect if the hardware and operating system are NUMA capable and enable Oracle NUMA support.

To enable this capability, the following underscore init.ora parameter need to be set.

_enable_NUMA_support=TRUE

 No additional steps are required.

This parameter replace and deprecate the init.ora parameter _enable_NUMA_optimization.
If _enable_NUMA_optimization is used instead of _enable_NUMA_support a warning will be displayed in the alert log:

..._enable_NUMA_optimization is deprecated please use _enable_NUMA_support instead....

 Once the init.ora parameter _enable_NUMA_support is set to TRUE and if the Oracle database version 11.2 runs in a NUMA capable environment, the alert log of the database instance should reflect that NUMA support has been enabled and what NUMA configuration was detected. For example, on a 8 NUMA domains Linux system with 48 cores:

...NUMA system found and support enabled (8 domains - 6,6,6,6,6,6,6,6)...

 Caution

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Recommendation:
Actions
 Steps to enable NUMA with Oracle Server Version 11.2:
  Caution
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.