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]

How will you change the block size in the initDB.ora file? Will the installer give you the option to change it during the installation?

[Former Member]

Anup

Yes, With the option "<b>Advanced</b> Database <b>Configuration</b>".

Regards

Vinod

[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.

[Former Member]

Hi,

db_block_size parameter sets the size in bytes of Oracle database blocks. Together with db_block_buffers ( DB_BLOCK_BUFFERS (Oracle)), it is used to determine the size of the Data Buffer (Oracle) in the SGA. The parameter db_block_size can only be set at the time of creating the database and cannot be changed afterwards.

The parameter db_block_size is set to 8192 bytes for most R/3 installations. It should not be modified.

Vinod

[Former Member]

Hi Vinod, I already talked to SAP about making the blksize larger in the BI environment and they agree with us. However I was wondering if it's possible to specify a new blksize during the installation, that will avoid the waste of my time to recreate the DB with a new blksize.

[Former Member]

Hi,

Then u can change this.Before creating DB go for Advanced or Expert options and modify db_block_size in init<sid>.ora file.

<ORACLE_HOME>/dbs/init<DBSID>.ora

Plz have a look on 830576,105047 and 632556.SAP rec 8K and depends on OS.

Vinod