Re: Error ORA-04031

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Wed, 13 Mar 2002 05:39:39 -0000
Message-ID: <u8ueflkuc0161b@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 Tue Mar 12 2002 - 23:39:39 CST