[Translated from mos] oracle NUMA support and 11gr2numa support are enabled in Oracle db 11gR2.

Source: Internet
Author: User

[Translated from mos] oracle NUMA support and 11gr2numa support are enabled in Oracle db 11gR2.
Enable oracle NUMA support in Oracle db 11gR2
Reference Original:
Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID 864633.1)
Applicable:
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 be used with large SMP multiprocessor environments with NUMA hardware.
Enabling Oracle NUMA support effectively uses the underlying NUMA hardware and may improve the database performance.

Oracle NUMA support requires a correct combination of hardware, OS, and oracle db version.
From oracle db 11.2.0.1, Oracle NUMA support is disabled by default.
This article describes how to enable Oracle NUMA support in the case of Oracle db 11gR2.
In environments earlier than Oracle db 11.2, NUMA recommendations and NUMA support can be found in the mos article: Note: 759565.1.
Be careful to enable NUMA support. Contact your hardware supplier for information about NUMA compatibility between your hardware and operating system.
Recommended:
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 stronugly recommended to mers who want to enable NUMA do sufficient testing before going into production.
Action:
To enable NUMA in oracle db 11.2, follow these steps:
When oracle db 11.2 is used in a NUMA-compatible environment, Oracle does not check the NUMA compatibility between hardware and OS by default, and Oracle NUMA support is not enabled.
Set the following implicit parameters to enable NUMA support

_enable_NUMA_support=TRUE
In addition, no other steps are required.
_ Enable_NUMA_support replaces _ enable_NUMA_optimization. If the _ enable_NUMA_optimization parameter is used to replace the _ enable_NUMA_support parameter, an alarm is reported in the alert log:
..._enable_NUMA_optimization is deprecated please use _enable_NUMA_support instead....
Once the _ enable_NUMA_support parameter is set in the parameter file and oracle db 11.2 runs in the NUMA compatible environment, the alert log of the database instance will have the feedback that NUMA support has been enabled, the NUMA configuration is detected.
For example, in 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)...
Warning:
Disabling or enabling will change the application performance.
Before enabling NUMA support in the production environment, we recommend that you evaluate it in the testing environment.
When Oracle NUMA support is disabled, the operating system and hardware configuration may need to be adjusted or reconfigured. Please consult your hardware supplier for more information and recommendations.
AIX (oracle ins 10102)

Install 11gR2 RAC in the AIX 6.1 + Veritas CFS environment as follows:
1. 11gR2 GI/RAC installation preparations
1.1 installation environment:
The hardware environment is a 2-node IBM pseries minicomputer. Each node has 32 physical CPUs, 509440 MB in memory, and the 32 6.1 MB swap space OS version is 64bit AIX 6100 (1228-06-09 ).

Setting Value
Machine and version AIX macleandb-007 1 6 00F71C964C00
Fully qualified host name macleandb-007
Platform 64-bit AIX
O/S Version 6.1.0.0
O/S Maintenance Level 6100-06
O/S Service Pack Level 6100-06-09-1228
Logged in as oracle
Last run as uid = 1101 (oracle) gid = 1000 (oinstall) groups = 1000 (oinstall), 1200 (dba), 1300 (asmdba)
Executed as Oracle home owner? Yes
RDA home directory/oracle/rda
RDA work directory/oracle/rda
Output file prefix RDA
Output file directory/oracle/rda/output
Setup profile DB11g
Perform network pings? No

Item Value
Processor (s) 32 Processor (s) Installed
[01]: PowerPC_POWER7 3864 MHz
[02]: PowerPC_POWER7 3864 MHz
[03]: PowerPC_POWER7 3864 MHz
[04]: PowerPC_POWER7 3864 MHz
[05]: PowerPC_POWER7 3864 MHz
[06]: PowerPC_POWER7 3864 MHz
[07]: PowerPC_POWER7 3864 MHz
[08]: PowerPC_POWER7 3864 MHz
[09]: PowerPC_POWER7 3864 MHz
[10]: PowerPC_POWER7 3864 MHz
[11]: PowerPC_POWER7 3864 MHz
[12]: PowerPC_POWER7 3864 MHz
[13]: PowerPC_POWER7 3864 MHz
[14]: PowerPC_POWER7 3864 MHz
[15]: PowerPC_POWER7 3864 MHz
[16]: PowerPC_POWER7 3864 MHz
[17]: PowerPC_POWER7 3864 MHz
[18]: PowerPC_POWER7 3864 MHz
[19]: PowerPC_POWER7 3864 MHz ...... remaining full text>


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.