Enable Oracle NUMA support with Oracle Server Version 11.2.0.1

edwardking888發表於2010-07-06

In this Document
  What is being announced?
     Recommendation:
  What do you need to do?
     Steps to enable NUMA with Oracle Server Version 11.2:
      Caution
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.0 to 11.2.0.2
Oracle Server - Standard Edition - Version: 11.2.0.1 to 11.2.0.2
Information in this document applies to any platform.
Oracle on NUMA capable hardware

What is being announced?

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:

  • Customers who have tuned their Database specifically for NUMA can continue to run with NUMA enabled with Oracle Server Version 11.2.0.1. 
  • It is strongly recommended to customers who want to enable NUMA do sufficient testing before going into production.

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

What do you need to do?

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

  • Disabling or enabling NUMA can change application performance.
  • It is strongly recommended to evaluate the performance before and after enabling NUMA in a test environment before going into production.
  • Operating system and/or hardware configuration may need to be tuned or reconfigured when disabling Oracle NUMA support. Consult your hardware vendor for more information or recommendation

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8183550/viewspace-667317/,如需轉載,請註明出處,否則將追究法律責任。

相關文章