Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle DB_BLOCK_SIZE and LINUX I/O

scottjhnApr 2 2012 — edited Apr 3 2012
This "_http://www.ixora.com.au/tips/buffered_block_size.htm_" suggests that if the operating system uses the buffered I/O, the database block size should match the file system buffer size exactly, in order to avoid the performance issue.

If the above statement is true, I'll have some questions to ask. For Linux OS, does it use buffered or direct I/O by default?

If it uses the buffered I/O by default, the file system buffer size is usually 4K; while the default Oracle database block size is 8K. There is the mismatch. According to the source above, there would be some performance issue. In that case, do I need to reset the DB_BLOCK_SIZE to 4K, to match the file system buffer size?


Thanks to help.

Scott
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Apr 2 2012
#general-database-discussions
6 comments
2,005 views