Re: ORA-04031

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 Apr 2002 21:15:19 +0200
Message-ID: <t6rtcu09eeou3jilbkvcq91o21bcg6uv48@4ax.com>

On Tue, 30 Apr 2002 19:01:09 GMT, "clueless" <ro_cright_at_hotmail.com> wrote:

>oracle on w2k new Dell server 2gig memory 56gig hd space.
>
>ORA-04031: unable to allocate 4248 bytes of shared memory ("shared
>pool","explain plan set statement_i...","sql area","kafco : qkacol")
>
>any ideas
>

Your shared pool is fragmented. You can try to resolve it by enlarging the shared pool, but this doesn't help always, depending on your use of pl/sql. Alter system flush shared_pool simply flushes the shared pool and you also resolve it, though with this command all your pl/sql code needs to be cached again.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 30 2002 - 14:15:19 CDT