Re: [Q] ORA-04031 unable to allocate shared memory

From: Andrew Zitelli <zitelli_at_tus.ssi1.com>
Date: 1996/08/08
Message-ID: <4udkfr$den_at_atlas.tus.ssi1.com>#1/1

duffy_at_cais.cais.com (MCC) wrote:
> I got an error message "ORA-04031; unable to allocate
> 740 bytes of shared memory".
<SNIP>
> The Oracle server is SUN Sparc with Solaris 2.5 and Oracle 7.2.3.

There is a known bug in this version (and several earlier versions) of Oracle, that causes this error. The normal remedies for 4031 errors (such as increasing the shared pool size) will only delay this error, not prevent it. Oracle support can provide a patch. Our 4031 errors ceased after we applyied the patch several months ago.

Andy Zitelli, Silicon Systems, Inc.

Received on Thu Aug 08 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Tom Platts: "Commit and Locking problems"
Previous message: J-P Korkiakoski: "How to capture error message using oraperl ?"
In reply to: MCC: "[Q] ORA-04031 unable to allocate shared memory"
In reply to MCC: "[Q] ORA-04031 unable to allocate shared memory"
Next in thread: Martin Bronstein: "Re: Host command"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message