Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Initialization Parameters, 17 of 188


BUFFER_POOL_KEEP

Parameter type: 

String 

Syntax: 

BUFFER_POOL_KEEP = {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_KEEP lets you save 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 KEEP buffer pool. You can also allocate to the KEEP 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_KEEP = 5

or you can specify a combination of buffers and LRU latches. Specifying LRU latches is optional:

BUFFER_POOL_KEEP = (BUFFERS: 400 [, LRU_LATCHES:3] )
 

This parameter is most useful in combination with BUFFER_POOL_RECYCLE.

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