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 laterOracle 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 |