Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index