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!

Finding appropriate block size?

YasuOct 14 2009 — edited Oct 27 2009

Hi All,

I believe this might be basic question, How to find appropriate block size for building an database to an specific application?

I had seen always default 8K block size is used every where(Around 300-350 databases i have seen till now)....but why and how do they estimate this block size blindly before creating production database.

Also in the same way how memory settings are finalized before creating database?

-Yasser

This post has been answered by Aman.... on Oct 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2009

Added on Oct 14 2009

#general-database-discussions

93 comments

10,033 views