Wednesday, October 23, 2019

NUMA on the Exadata and ORA-04031

At the very beginning when Exadata appeared at 2010 the settings of Linux OS and Oracle RDBMS were configured to use flat memory. There were no NUMA settings despite the SUN 4275 server is actualy NUMA server. And some notes at old times prohibited using NUMA settings on the Exadata.

But starting from November 2018 (
Exadata image 18.10), Oracle silently enabled NUMA settings for Exadata. Which can increase appearance of ORA-04031.

Here is a some words about enabling NUMA on Exadata in
2378765.1:
" Normally, PX message buffers come out of the large pool as long as sga_target or memory_target is set. However, when "_enable_NUMA_support" is 'TRUE' and you are running on Exadata (then _px_numa_support_enabled is 'TRUE') causes PX message buffers to be allocated from the numa pool. "

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...