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 user-specified size rounded up to the granule size 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).

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘DB_KEEP_CACHE_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_keep_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of KEEP buffer pool for standard block size buffers

Oracle initializatoin parameters