Show TOC

DB_BLOCK_BUFFERS (Oracle)Locate this document in the navigation structure

DB_BLOCK_BUFFERS (Oracle)

This parameter sets the number of Oracle database blocks stored in the database buffer cache of the System Global Area (SGA). Each database block buffer is equal to one Oracle database block. The data read from the data files is temporarily stored in the database buffer cache.

The product of db_block_buffers and db_block_size ( DB_BLOCK_SIZE (Oracle)) is the size of the Data Buffer (Oracle).

The minimum value for this parameter is 4. The maximum value depends on the operating system. The SAP default is 3000. You should not normally reduce this value. Large systems typically run with much higher values.

See also:

Monitoring the Data Buffer (Oracle)