DB_CACHE_SIZE is must or not
Satender Dalal, August 02, 2017 - 10:20 am UTC
Hi Tom,
If SGA_TARGET or MEMORY_TARGET are set or either of them is set, then will it be fine if DB_CACHE_SIZE is 0.
Or we must set some value to DB_CACHE_SIZE, for performace improvement.
(I am talking about this for performance improvement)
August 03, 2017 - 1:06 am UTC
If they are set, the setting db_cache_size acts as a lower limit. For example:
sga_target = 1000M
means I'll share out that 1000M, and if I need (say) more shared pool, the database can shrink the buffer cache down to whatever it wants to meet that need.
sga_target = 1000M
db_cache_size = 400M
means the same, but no matter what, the database will not shrink the buffer cache to less than 400m.