How to setup BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE

From: <llyx_at_hotmail.com>
Date: Mon, 13 Sep 1999 18:45:47 GMT
Message-ID: <7rjgon$29t$1@nnrp1.deja.com>

I setup these parameters in initSID.ora as

		BUFFER_POOL_KEEP = (buffer:1000,lru_latches:1)
		BUFFER_POOL_RECYCLE = (buffer:500,lru_latches:1)
		DB_BLOCK_LRU_LATCHES = 6

and got ORA-00378, saying either number of buffer or lru_latches is too small. I try to increase but does not work. Oracle manual says one lru_latches has to handle at least 50 buffers.

I appreciate your help

Thanks in advance.

David

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 13:45:47 CDT