|
Parameter type
|
String
|
|
Syntax
|
BUFFER_POOL_RECYCLE = {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_RECYCLE_CACHE_SIZE parameter. Oracle recommends that you use DB_RECYCLE_CACHE_SIZE instead. Also, BUFFER_POOL_RECYCLE cannot be combined with the new dynamic DB_RECYCLE_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error. BUFFER_POOL_RECYCLE is retained for backward compatibility only.
|
BUFFER_POOL_RECYCLE lets you limit the size of 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 RECYCLE buffer pool. You can also allocate to the RECYCLE 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_RECYCLE = 5
Or, you can specify a combination of buffers and LRU latches. Specifying LRU latches is optional:
BUFFER_POOL_RECYCLE = (BUFFERS:50, LRU_LATCHES:1)
This parameter is most useful in combination with the BUFFER_POOL_KEEP parameter.
