How to turn on NUMA support in Oracle database

This article mainly introduces "how to open NUMA support in Oracle database". In daily operation, I believe many people have doubts about how to open NUMA support in Oracle database. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the question of "how to open NUMA support in Oracle database". Next, please follow the editor to study!

Introduction to NUMA

NUMA (Non Uniform Memory Access Architecture, non-uniform memory access) divides a computer into multiple nodes (node), each node has multiple CPU, the node uses a common memory controller, and the nodes connect and exchange information through interconnection modules. Therefore, all the memory of the node is equal to all the CPU of this node, and different for all CPU in other nodes. Although each CPU can access the entire system memory, the memory access speed of the local node is the fastest (without the interconnection module), and the memory speed of the non-local node is slower (through the interconnection module).

Oracle Database support for NUMA

Starting from 11.2, Oracle does not enable NUMA support by default, nor does it affect the hardware platform or whether the operating system supports NUMA. To enable NUMA support, you need to configure it manually.

In 11.2, you only need to set an implicit parameter to turn on NUMA support:

_ enable_NUMA_support=TRUE

Then restart the database. If the setting is successful, it will appear in alert log:

... NUMA system found and support enabled...

Information like this.

In 12c, in addition to setting the above parameter, you need to set another parameter:

_ px_numa_support_enabled=TRUE

Enabling NUMA support can theoretically improve performance, but enabling NUMA in a production environment must undergo rigorous testing.

At this point, the study on "how to turn on NUMA support in Oracle database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!