Oracle Database - DB_BLOCK_SIZE initialization parameter

Card Puncher Data Processing

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.

Metadata

Show

gerardnico@orcl>show parameter DB_BLOCK_SIZE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
db_block_size                        integer     8192

View

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





Discover More
Oracle Segment Extent Data Block
Oracle Database - (Data|Db|Logical|Oracle) Block or Page

Articles which talk : block management. ?? At the finest level of granularity in the logical structure of an Oracle Database, the data is stored in data blocks. The data block sizes should be a...
Card Puncher Data Processing
Oracle Database - Table Size

How to calculate the space of a table ? Then: The above shows us: we have 55 blocks allocated to the table 53 blocks are totally empty (above the HWM) 1 block contains data (the other block...



Share this page:
Follow us:
Task Runner