Expected cache memory not being used on NUMA platform (Doc ID 456232.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
Oracle Server - Standard Edition - Version: 10.2.0.1 to 11.1.0.7
Microsoft Windows Server 2003 (64-bit Itanium)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)

Symptoms

Platforms listed above are Windows, but evidence would suggest the symptoms may be observed on any NUMA platform.

You are running on 10.2.0.x on a NUMA box.

Query second time around does NOT run faster although you would expect at least some blocks to be cached. When checking using a 10046 trace you see that the blocks are read from disk on all subsequent executions.

Due to this issue, the expected improvement due to caching is not occurring.




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms