| Property | Description |
|---|---|
| Parameter type | Big integer |
| Syntax | DB_KEEP_CACHE_SIZE = integer [K | M | G] |
| Default value | 0 (DB_KEEP_CACHE_SIZE is not configured by default) |
| Modifiable | ALTER SYSTEM |
| Range of values | Minimum: 0 (values greater than zero are automatically modified to be either the granule size * number of processor groups, or 4 MB * number of CPUs, whichever is greater)
Maximum: operating system-dependent |
| Basic | No |
DB_KEEP_CACHE_SIZE specifies the size of the KEEP buffer pool. The size of the buffers in the KEEP buffer pool is the primary block size (the block size defined by the DB_BLOCK_SIZE initialization parameter).
When you modify the value of DB_KEEP_CACHE_SIZE using ALTER SYSTEM, you must restart the database for the new value to take effect.
See Also:
Oracle Database Performance Tuning Guide for information on setting these parameters and on using multiple buffer pools