Question Re: Oracle Block Size in Technology Q&A

Oracle Block Size

Former Member — Wed, 21 Mar 2007 13:51:04 GMT

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?

Re: Oracle Block Size

Former Member — Wed, 21 Mar 2007 13:57:39 GMT

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

Re: Oracle Block Size

Former Member — Wed, 21 Mar 2007 14:04:21 GMT

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.

Re: Oracle Block Size

Former Member — Wed, 21 Mar 2007 14:16:56 GMT

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

Re: Oracle Block Size

Former Member — Sat, 24 Mar 2007 21:17:25 GMT

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.

Re: Oracle Block Size

Former Member — Sat, 24 Mar 2007 21:26:09 GMT

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?

Re: Oracle Block Size

Former Member — Wed, 28 Mar 2007 07:31:58 GMT

Anup

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

Regards

Vinod