Re: How to setup BUFFER_POOL_KEEP and BUFFER_POOL

From: <rspeaker_at_my-deja.com>
Date: Mon, 13 Sep 1999 19:45:52 GMT
Message-ID: <7rjk9c$57a$1@nnrp1.deja.com>

you didn't post the value of DB_BLOCK_BUFFERS, but make sure it is large enough to allow the 1000 buffers for KEEP, the 500 buffers for RECYCLE, and enough left for the "DEFAULT" pool.

HTH,
Roy

In article <7rjgon$29t$1_at_nnrp1.deja.com>, 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, 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.
>

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

Re: How to setup BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE