Show TOC

DB_BLOCK_SIZE (Oracle)Locate this document in the navigation structure

 DB_BLOCK_SIZE (Oracle)

This 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 parameterdb_block_size is set to 8192 bytes for most SAP installations. It should not be modified.