Re: db_block_size

>> Anybody have information about creating a database with a non-default
>> block size? Particularly interested in when you supply the info upon
>> database creation.

Oracle recommends that the db_block_size be an integer multiple of operating system's block size. For instance, if the Unix OS file system has block size of 1K, then the db_block_size can be 1K, 2K, 4K, etc. If the db_block_size is not an integer multiple of the OS block size, you will see unnecessary reads (or writes). The previous post was correct that you need to do this before you create the database. Once the database is created, you can not change this parameter (not without recreating the db).

Hope that helps,
Brian Peasland
peasland_at_msn.com Received on Thu May 20 1999 - 22:34:37 CDT