Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Initialization Parameters, 19 of 222
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:
|
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|