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 Unveiling Indonesia’s Financial Market: Navigating Debt Collection Systems 11th March, 2024 The Proven Results of JurisTech’s Digital Onboarding Platform 24th January, 2024 Driving Economies Through JurisTech’s Outstanding Impact on the Fintech Industry 15th January, 2024