Re: Increase db_block_buffers causes ORA-04031 error?

From: Joop <jg_nospam_at_xs4all.nl>
Date: Wed, 3 Sep 2003 23:11:51 +0200
Message-ID: <3f56591a$0$49112$e4fe514c@news.xs4all.nl>

Original Message ----- From: "Brian Peasland" <dba_at_remove_spam.peasland.com> Newsgroups: comp.databases.oracle.server Sent: Wednesday, September 03, 2003 9:18 PM Subject: 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
>

That's exactly what i thought, so it could be a coincidence. But to exclude I indeed turned back the increase of the db_block_buffers. So we will see. Received on Wed Sep 03 2003 - 16:11:51 CDT