Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 17 of 220
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-2001, Oracle Corporation. All Rights Reserved. |
|