This content has been marked as final. Show 7 replies
rac100g wrote:What's the default block size of your db? Looks like you are not using 8kb as the default one. If that's the case, you must set the non-default cache for that block size using the parameter db_8k_cache_size since the default cache won't be able to manage it. And the automatic management does not for nk_cache_size parameters but only for default cache parameter-db_cache_size.
I am occasionally getting this ora-00379 error.
ORA-00603: ORACLE server session terminated by fatal error
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K
ORA-00604: error occurred at recursive SQL level 2
I don't have any specific value set to 8k, 16k, 32k cache size and I have allowed Oracle to self manage the memory. To tackle this particular error should I set a large value from the SGA propotion and leave others (16k, 32k, etc) unchanged?
I read the doc you posted.
In my case, I don't have any of these set,
My question is asking if we need to allocate a fixed or minimum cache size for this particular 8k db block.
rac100g wrote:It's not hidden but auto-tuned parameter since its using two underscores. The hidden parameters start with a single underscore. The db_cache_size=0 is because you are using the automatic SGA memory management.
From RDA, i see there is a hidden parameter,
__db_cache_size which is more than 2000000000
currently the db_cache_size is also set to 0.