DB_KEEP_CACHE_SIZE


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: