Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

BUFFER_POOL_RECYCLE

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.

See Also: