Oracle Block Size

[#1]

Can I pick a different block size during SAP installation? I want to build a new environment with 32K blksize instead of the regular 8k. Is it possible to do it during the installation?

[Former Member]

Hi,

You have to set the parameter value for DB_BLOCK_SIZE in initSID.ora file to 32K

Please note that this has to be done before creation of the database and once created we cannot change the value.

So in this case if your db is already created with default block size, u need to recreate it with new size.

Also, oracle block size should always be a multiple of Operating System block size.

Hope this clarifies.

Regards,

Sandeep.