1.68 DB_BLOCK_BUFFERS

DB_BLOCK_BUFFERS specifies the number of database buffers in the buffer cache.

Property Description

Parameter type

Integer

Default value

0

Modifiable

No

Modifiable in a PDB

No

Range of values

50 to an operating system-specific maximum

Basic

No

Oracle RAC

Multiple instances can have different values, and you can change the values as needed.

Note:

DB_BLOCK_BUFFERS cannot be combined with the dynamic DB_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error.

DB_BLOCK_BUFFERS is one of several parameters that contribute to the total memory requirements of the SGA of an instance.

This parameter, together with DB_BLOCK_SIZE, determines the total size of the buffer cache. Effective use of the buffer cache can greatly reduce the I/O load on the database. DB_BLOCK_SIZE can be specified only when the database is first created, so you use DB_BLOCK_BUFFERS to control the size of the buffer cache.

Note:

The DB_BLOCK_BUFFERS initialization parameter is deprecated. It is maintained for backward compatibility.

Oracle recommends that you use DB_CACHE_SIZE instead.

See Also:

"DB_CACHE_SIZE"