Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Initialization Parameters, 18 of 188


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. 

Parameter class: 

Static 

Default value: 

None 

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 value of the DB_BLOCK_LRU_LATCHES parameter).

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 BUFFER_POOL_KEEP.

See Also: Oracle8i Designing and Tuning for Performance for information on setting these parameters and on using multiple buffer pools. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index