Oracle Database - DB_BLOCK_SIZE initialization parameter

> Database > Oracle Database

1 - About

Value : 16K of 32K (* 1024)

This parameter in the init.ora is the most important. This can be done only during creation time. If you have already created the Database you cannot change this value. You will have to re-create the Database with a different size.

When you start to think about larger block sizes, remember that a 32KB undo block size can be a source of wasted I/O.

This block size is used for the SYSTEM tablespace and by default in other tablespaces.

The maximum value to which you can set the DB_BLOCK_SIZE is 16 KB on Linux x86. It is 32 KB on other platforms.

Advertising

3 - Metadata

3.1 - Show

[email protected]>SHOW parameter DB_BLOCK_SIZE
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
db_block_size                        INTEGER     8192

3.2 - View

SELECT
  *
FROM
  v$parameter
WHERE
  name = LOWER('DB_BLOCK_SIZE');