• 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.

    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 | 2020-03-27T17:33:46+00:00 14th October, 2013|Insights|

    About the Author:

    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.