1.63 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: