Re: How to setup BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 13 Sep 1999 20:04:37 GMT
Message-ID: <37de5703.3206581@news.siol.net>

On Mon, 13 Sep 1999 18:45:47 GMT, llyx_at_hotmail.com wrote:

>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

How large is your buffer cache?

You could be getting ORA-00378 if your DB_BLOCK_BUFFERS is less than sum of BUFFER_POOL_KEEP buffers + BUFFER_POOL_RECYCLE buffers.

>Thanks in advance.
>
>David

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Sep 13 1999 - 15:04:37 CDT