Re: ORA-04031: unable to allocate 4096 bytes of shared memory

From: Scott Gamble <zifnab_at_reddragon.org>
Date: Tue, 16 Apr 2002 12:55:52 GMT
Message-ID: <sbVu8.56861$2w4.632314@news.webusenet.com>

dirk.versavel_at_smartlounge.be (Dirk Versavel) wrote in news:4eeeef52.0204152330.7ad9f467_at_posting.google.com:

> Dear,
>
> I'm running oracle 8.1.7 on RedHat Linux 6.2.
>
> Since some time (since the database is more intensively used), the
> database stops responding about once a week. A database restart is
> necessary.
>
> The error is:
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","BEGIN :p := CTX_QUERY.PREFER...","PL/SQL MPCODE","BAMIMA: Bam
> Buffer")
>

You didn't specify which patchset of 8.1.7, but I seem to recall a bug in 8.1.7.1 that caused a 4031 quite regularly due to a memory leak. A quick search of metalink should confirm that.

Scott Gamble Received on Tue Apr 16 2002 - 07:55:52 CDT