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!

What is the impact of DB block size being smaller than the OS block

user9502721Apr 13 2015 — edited Apr 13 2015

Our Windows sys admin increased the OS block size to 64KB without advice. Three (3) systems were shipped with DB created with default DB_block size=8KB.

The DB bock size should be equal to the OS block or a multiple, which is not the case here.

Does anyone knows the impact of such block sizes setup.

Would it causes space or performance issues?

Would Oracle only store 8k per block wasting the left over space? or,

Would Oracle suffer performance reading / writing 8K pieces at a time?

Any known figure about performance impact?

Should I backup the DB (rman), reformat the drive and restore the DB; or impact are not enough significant.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2015
Added on Apr 13 2015
17 comments
2,013 views