Buffer Cache Not Fully Allocated Immediately If DB_CACHE_SIZE Is Greater Than 100GB
Last updated on MAY 22, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Solaris on SPARC (64-bit)
With manual memory management on 184.108.40.206, setting db_cache_size greater than 100GB, however allocated buffer cache didn't honor the setting after starting the database: only 72GB memory allocated for buffer cache at the beginning. And after one month (or less time), the buffer cache size eventually honors the setting (increased to more than 100GB).
The problem seems only seen when setting db_cache_size greater than 100GB (setting it to 80GB cannot recreate the problem).
Setting hide parameter '_memory_imm_mode_without_autosga'= FALSE can't help.
For db_cache_size= 110G, total sga = 120G
With manual memory management on 220.127.116.11, setting db_cache_size greater than 100GB
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