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 team at JurisTech's Marketing & Communications, a group of digital marketing strategists and content creators, delivers invaluable insights and expertise drawn from fintech experts across the entire JurisTech team. For media queries, get in touch at mac@juristech.net. Related Posts Exciting Opportunities With Generative AI in Digital Onboarding 23rd July, 2024 Everything You Need To Know About Composite AI In The Financial Industry 5th July, 2024 Why the Financial Industry Uses Low-code/No-code APIs Now 21st June, 2024