Re: ORA-04031

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 2 May 2002 22:56:53 -0700
Message-ID: <7ca2852.0205022156.a8af836@posting.google.com>

You could try to pin your frequently used big pl/sql packages and procedures to avoid fragmentation in the shared pool. Also pin the dbms_output,diutil etc sys owned packages if possible.

HTH
-Ashok

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:<94Jz8.4244$Yq7.2503064705_at_newssvr21.news.prodigy.com>...
> Check this post:
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3ccefcda1598ffff;act=ST;
> f=20;t=109
>
> It has resolutions to this problem.
>
> Hope that helps,
>
> Trifon Anguelov
> Senior Oracle DBA
>
> http://www.dbaclick.com
>
> ----------------------------------------------------------------------------
> ----------------------
>
> "clueless" <ro_cright_at_hotmail.com> wrote in message
> news:VRBz8.18930$f5.1489052_at_news...
> > 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
> >
> >
Received on Fri May 03 2002 - 00:56:53 CDT