"From translator MOS article" in Oracle DB 11GR2 version number is enabled for Oracle NUMA support

Source: Internet
Author: User

Oracle NUMA support is enabled on Oracle DB 11GR2 version number
Reference Original:
Enable Oracle NUMA Support with Oracle Server Version 11gR2 (file ID 864633.1)
Application:
Oracle database-enterprise edition-version 11.2.0.1 and later
Oracle Database-standard edition-version 11.2.0.1 and later
Information in this document applies to any platform.
Oracle on NUMA capable hardware
Checked for relevance on 11-mar-2013***

Details:
Oracle Numa (Non Uniform Memory Architecture) support can is used with large SMP multiprocessor environments with NUMA HARDW Is.


Enabling Oracle NUMA support effectively uses the underlying NUMA hardware. and may improve DB performance.

Oracle NUMA support requires the right combination of hardware, OS, and Oracle DB version.
Starting with Oracle DB 11.2.0.1, the default Oracle NUMA support is disabled.
This article describes how Oracle NUMA support is enabled in the case of Oracle DB 11GR2
In an environment with a version number prior to Oracle db 11.2. For the use of NUMA recommendations and support for NUMA, see MOS article: note:759565.1
Be careful to enable NUMA support. Contact your hardware vendor to obtain information about NUMA compatibility for your hardware and operating system.


Recommended:
Customers who has tuned their Database specifically for NUMA can continue to run with NUMA enabled with Oracle Server Ver Sion 11.2.0.1.
It is strongly recommended to customers who want to enable NUMA does sufficient testing before going into production.
Let's go:
Steps to enable NUMA in Oracle DB 11.2:
When using Oracle DB 11.2 in a NUMA-compliant environment, the default Oracle will not detect NUMA compatibility for hardware and OS, and will not enable Oracle NUMA support
Set an implied parameter such as the following to enable NUMA support

_enable_numa_support=true
In addition, no other steps are required.
_enable_numa_support This number replaces the _enable_numa_optimization. If you use _enable_numa_optimization to replace _enable_numa_support, there will be an alarm in alert log:
... _enable_numa_optimization is deprecated you use _enable_numa_support instead ....
Once the _enable_numa_support parameter is set in the parameters file. and Oracle DB 11.2 executes in a NUMA-compliant environment. Then the alert log for the DB instance will have feedback that NUMA support has been enabled and can show what NUMA configuration was detected.
For example, on a 8 NUMA domains Linux system with cores:
... NUMA system found and support enabled (8 domains-6,6,6,6,6,6,6,6) ...
Warning:
Performance disabling or enabling application changes
In a production environment, before NUMA support is enabled. Recommend a review in a test environment
When Oracle NUMA support is disabled, the operating system and hardware configuration may need to be tuned or another structure, consult your hardware vendor to obtain a large amount of additional information and recommendations.

"From translator MOS article" in Oracle DB 11GR2 version number is enabled for Oracle NUMA support

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.