Re: How to setup BUFFER_POOL_KEEP and BUFFER_POOL_RECYCLE

There appear to be two different sets of syntax for these buffer pools which are version and operating system dependent.

Try:

    BUFFER_POOL_KEEP = (1000:1)
    BUFFER_POOL_RECYCLE = (500:1) --

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

llyx_at_hotmail.com wrote in message <7rlk6k$ii5$1_at_nnrp1.deja.com>...
>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.
Received on Tue Sep 14 1999 - 09:07:54 CDT