Expected cache memory not being used on NUMA platform
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 18.104.22.168
Oracle Server - Standard Edition - Version: 10.2.0.1 to 22.214.171.124
Microsoft Windows Server 2003 (64-bit Itanium)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)
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.
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