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

From: Paul Drake <bdbafh_at_gmail.com>
Date: 1 Jul 2004 22:20:27 -0700
Message-ID: <910046b4.0407012120.734b2532@posting.google.com>

Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.01.22.59.39.434649_at_sbcglobal.net>...
> On Thu, 01 Jul 2004 10:51:28 +0200, cat54me wrote:
>
> > "ORA-04031: unable to allocate 8192 bytes of shared memory"
> >
> > What is the cause? How do I fix it?
> >
> > Thanks in advance!
>
> It is likely you are encountering feature 1397603 which
> effects 8.1.7. The workaround is to set the following
> init.ora parameter to zero:
>
> _db_handles_cached = 0

huh?
> Hi all,
> I am running Oracle 9i R1 64-bit on Solaris 8 SPARC.

Mladen,

you should have been sucking down brews and oysters at David Copperfields instead of posting that one.

Paul Received on Fri Jul 02 2004 - 00:20:27 CDT