Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple Block Sizes & Data Buffer Cache (SGA)

Dev_SQLMar 18 2020 — edited Mar 18 2020

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.

This post has been answered by Jonathan Lewis on Mar 18 2020
Jump to Answer
Comments
Post Details
Added on Mar 18 2020
3 comments
601 views