Oracle disk block,OS block,disk block
Hi,
I really have simple question, but the one I had trouble setting straight up.
I general database literature, it is said that disk blocks with data is transferred into buffer cache of DBMS for further analysis.
In Oracle database we can have Oracle data block (I understand it's structure) that maps on multiple OS block. But we all know that OS can reference multiple disk blocks. Is it safe to say then that one Oracle block maps to multiple disk blocks?
In the case where Oracle data block is 2K, and disk block is 4K, is it safe to say this is not optimal cinfiguration (like in Oracle block-OS block analogy in Oracle documentation)?
I really have simple question, but the one I had trouble setting straight up.
I general database literature, it is said that disk blocks with data is transferred into buffer cache of DBMS for further analysis.
In Oracle database we can have Oracle data block (I understand it's structure) that maps on multiple OS block. But we all know that OS can reference multiple disk blocks. Is it safe to say then that one Oracle block maps to multiple disk blocks?
In the case where Oracle data block is 2K, and disk block is 4K, is it safe to say this is not optimal cinfiguration (like in Oracle block-OS block analogy in Oracle documentation)?
0