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 184.108.40.206
Oracle Server - Standard Edition - Version: 10.2.0.1 to 220.127.116.11
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!