Re: How to setup BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE

DB_BLOCK_BUFFERS = 4000
DB_BLOCK_SIZE = 8192 and I am using oracle 8.1.5.

In article <7rjk9c$57a$1_at_nnrp1.deja.com>,   rspeaker_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 08:56:44 CDT