1.73 DB_BLOCK_BUFFERS
DB_BLOCK_BUFFERS
specifies the number of database buffers in the buffer cache.
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
|
Modifiable |
No |
Modifiable in a PDB |
No |
Range of values |
|
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: