Re: Cannot create keep pool ...

zeb wrote:

> Hi,
>
> I try to keep a table en SGA
> so I put :
> db_block_buffers = 40000
> buffer_pool_keep = 6200
>
> When I start I have the following error:
> SVRMGR> startup
> ORA-00378: buffer pools cannot be created as specified
> SVRMGR>
>
> Something I miss ???

From memory (which is all I have to go on as far as 8.1.6 is concerned, it being so old and out of support), the parameter generally uses a rather different syntax to set it, because the syntax you're using doesn't do enough to sort out the latches:

buffer_pool_keep=(Buffers:6200, lru_latches:5)

(The 5 there is just an example). In other words, the buffer pool you've asked for can't be created because you've not configured your latches properly. You'll need a total number of them set with db_block_lru_latches, and then the "5" entry is deducted from that total. And bear in mind that a latch has to look after at least 50 buffers, so an entry of 620 wouldn't work, for example.

If you go to http://tahiti.oracle.com and click around the 8.1.7 documentation, you'll find the exact error message you've got described in full detail. You can then check the initialisation parameters section to see how DB_BLOCK_LRU_LATCHES, BUFFER_POOL_KEEP and anything else can be configured.

And you ought to be thinking (or getting the man who writes the cheques to think) about upgrading to at least 8.1.7, but preferably 9i or beyond.

Regards
HJR
> Thanks in advance
>
>
> Oracle 8.1.6
> WNT 4
Received on Tue Oct 19 2004 - 14:41:19 CDT