Hi All,
I have a doubt on Non Standard Buffer Cache (NSBC), assume I have multiple tablespaces with different block sizes as 2K, 4K and 8K, as we get different block sizes,
we need to configure the Cache Size accordingly as given below.
DB_BLOCK_SIZE=8192
DB_CACHE_SIZE=400M
DB_2K_CACHE_SIZE=500M
DB_4K_CACHE_SIZE=800M
My question, since we have defined 3 Cache Sizes, in the SGA, will we get 3 different Data Buffer Caches instead of just one?
One with the standard block size 8K, the second buffer cache with 2K block size and the third buffer cache with 4K block size.
We also need to assign memory size for each of them as show above, like 400M, 500M and 800M respectively.
Is my above understanding correct? Please clarify, thank you so much.