Re: Error ORA-04031

Had this a few weeks back (and tore my hair out!).

Flushing shared pool may not necessarily do anything, in fact can make it worse.
Try restarting the database initially. This will definately clear memory and make all memory blocks contigious. Longer term, try pinning large and often used packages to the shared pool and look at the init.ora settings relating to shared pool. Also, look at documents in Metalink.

M

"Stephen Ashmore" <sashmore_at_neonramp.com> wrote in message news:<u8ueflkuc0161b_at_corp.supernews.com>...
> This is a common problem caused by fragmentation of your shared pool.
> For a short term solution issue
> alter system flush shared pool;
>
> For a long term fix investigate setting init.ora parameter:
> shared_pool_reserved_size
> It wil aid in reducing fragmentation.
>
> There is also a bug in early 8.1.7 versions where there is a meomory leak.
> Upgrading to 8.1.7.2 will resolve it.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> "Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message
> news:a6n30r$5h4$1_at_wanadoo.fr...
> > Hello
> >
> > I have this error on the memory shared, especially on Shared Pool. However
> I
> > think that the size of this zone is correct For information it does not
> have
> > there a recursive call procedure.
> > Very cordially
> >
> >
Received on Wed Mar 13 2002 - 08:32:41 CST