My Oracle Support Banner

How To Disable NUMA for LSH/DMW (Doc ID 2818419.1)

Last updated on DECEMBER 13, 2024

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.0.0 and later
Oracle Life Sciences Data Hub - Version 3.0.0 and later
Information in this document applies to any platform.

Goal

After July CPU 2021 Patch, Oracle Database NUMA (Non Uniform Memory Architecture) support is enabled by default. This may impact the performance of SQLs associated with (Oracle Life Sciences Data Management Workbench) DMW product.

In order to improve the DMW performance, the following Database parameters should be disabled:

_enable_NUMA_support       : FALSE
_enable_NUMA_optimization : FALSE

Solution

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
Goal
Solution

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