First page Back Continue Last page Graphics
DB_CACHE_SIZE
Controls size of buffer cache
Replaces DB_BLOCK_BUFFERS
Specify in bytes
Required if multiple block sizes desired
8i example
Equivalent 9i example
Notes:
In Oracle8i, DB_BLOCK_SIZE and DB_BLOCK_BUFFERS define the size of the database buffer cache. The DB_BLOCK_BUFFERS initialization parameter has been deprecated (still supported for now but replaced) in Oracle9i. It has been replaced with the DB_CACHE_SIZE initialization parameter. DB_CACHE_SIZE is defined in bytes and allocates memory in blocks based on the standard block size just as the DB_BLOCK_BUFFERS parameter did in earlier Oracle releases. DB_CACHE_SIZE and DB_BLOCK_BUFFERS cannot be defined at the same time.
DB_CACHE_SIZE must be used if you intend to incorporate multiple block sizes into your database.
Use DB_CACHE_SIZE instead of DB_BLOCK_BUFFERS even though DB_BLOCK_BUFFERS is compatible in Oracle9i. This will give you the needed flexibility that might be needed later if you have a need for multiple block sizes.