NUMA and database headaches Source: Wikipedia NUMA stands for non-uniform memory access. It is a memory architecture for multiple CPU systems where some memory is local to specific CPUs, and accessing remote memory (which is local to another CPU) is slower. This is commonly found in 8-CPU systems. Apparently many databases have problems using NUMA. PostgreSQL MySQL, as reported by the Twitter team. Oracle has built-in support for NUMA servers. However it comes at a cost. Higher CPU utilisation and slower file system utilities. So by default, it is disabled in Oracle databases. This is explained in gory detail by Kevin Closson. Read Michael Wilson’s blog for instructions for 11gR2. And it’s worse on 10gR2. I don’t know about Oracle 12c but I suspect it is also disabled by default. By JurisTech| 2020-03-27T17:33:46+00:00 14th October, 2013|Insights| About the Author: JurisTech The Marketing & Communications team at JurisTech comprises skilled digital marketing strategists and content creators who deliver invaluable insights drawn from our experts in lending and recovery software solutions. For media queries, please contact us at mac@juristech.net.au. Related Posts Scaling Digital Customer Onboarding: Gain an Edge with Cloud-Native Applications 13th March, 2025 Everything You Need to Know About Scalable Banking: AI, Cloud-Native Tech, and Digital Transformation 11th March, 2025 6 Game-Changing Use Cases of Generative AI in Lending and Recovery 20th February, 2025