Re: Increase db_block_buffers causes ORA-04031 error?

ORA-04031 indicates that you do not have enough free memory in the Shared Pool. DB_BLOCK_BUFFERS affects a different memory structure in the SGA. So the two aren't really related. But to be sure, you can set DB_BLOCK_BUFFERS back and see if this stops your ORA-4031 errors.

HTH,
Brian

Joop wrote:
>
> On a Oracle 8.1.7.4 database on AIX we increased the db_block_buffers
> parameter because of a bad buffer cache hit ratio.
>
> After that we had several crashes of the application with a ORA-04031 error.
> Can there be a cause between these?

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"