Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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?

0 Likes

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Former Member
‎2007 Mar 21 1:57 PM
0 Likes

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

Show replies
Show replies
Former Member
‎2007 Mar 21 2:04 PM
0 Likes

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
‎2007 Mar 21 2:16 PM
0 Likes

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

Ask a Question