|
Parameter type
|
String
|
|
Syntax
|
BUFFER_POOL_KEEP = {integer |
(BUFFERS:integer, LRU_LATCHES:integer)}
where integer is the number of buffers and, optionally, the number of LRU latches.
|
|
Default value
|
There is no default value.
|
|
Parameter class
|
Static
|
Note:
This parameter is deprecated in favor of the DB_KEEP_CACHE_SIZE parameter. Oracle recommends that you use DB_KEEP_CACHE_SIZE instead. Also, BUFFER_POOL_KEEP cannot be combined with the new dynamic DB_KEEP_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error. BUFFER_POOL_KEEP is retained for backward compatibility only.
|
BUFFER_POOL_KEEP lets you save objects in the buffer cache by setting aside a portion of the total number of buffers (the value of the DB_BLOCK_BUFFERS parameter) as a KEEP buffer pool. You can also allocate to the KEEP buffer pool a specified portion of the total number of LRU latches.
The string value can take one of two forms. You can simply specify a buffer count:
BUFFER_POOL_KEEP = 5
Or, you can specify a combination of buffers and LRU latches. Specifying LRU latches is optional:
BUFFER_POOL_KEEP = (BUFFERS:400, LRU_LATCHES:3)
This parameter is most useful in combination with the BUFFER_POOL_RECYCLE parameter.
