BUFFER_POOL_KEEP

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.

See Also: "BUFFER_POOL_RECYCLE" Oracle9i Database Performance Guide and Reference for information on setting these parameters and on using multiple buffer pools