DB_CACHE

DB_CACHE_SIZE

Property	Description
Parameter type	Big integer
Syntax	`DB_CACHE_SIZE =` `integer` `[K \| M \| G]`
Default value	If `SGA_TARGET` is set: If the parameter is not specified, then the default is `0` (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool. If `SGA_TARGET` is not set: 48 MB, rounded up to the nearest granule size
Modifiable	`ALTER SYSTEM`
Basic	No

DB_CACHE_SIZE specifies the size of the DEFAULT buffer pool for buffers with the primary block size (the block size defined by the DB_BLOCK_SIZE initialization parameter).

The value must be at least the size of one granule (smaller values are automatically rounded up to the granule size). A value of zero is illegal because zero is the size of the DEFAULT pool for the standard block size, which is the block size for the SYSTEM tablespace.

See Also:

Oracle Database Performance Tuning Guide and Oracle Database Administrator's Guide for more information on setting this parameter