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

flush shared pool n try..!!

I have tried this and worked just y'day.

Alter system flush shared_pool;

Try n let me know..

• Chirag

On Thu, 3 Mar 2005 18:55:57 +0000, Jared Still <jkstill_at_gmail.com> wrote:
> A start may be to find out where some of the memory is.
> This will get you started.
>
> break on report
> compute sum of value on report
> compute sum of bytes on report
>
> select *
> from v$sgastat
> order by upper(name)
> /
>
>
> On Thu, 3 Mar 2005 08:06:33 -0600, Smith, Ron L. <rlsmith_at_kmg.com> wrote:
> > I have a couple of unrelated Oracle 8.1.7 databases that occasionally
> > getting the following error:
> > ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
> > pool","unknown object","sga heap","state objects")=20
> >
> > Flushing the Shared Pool does not help the problem. The size of the
> > Shared Pool has been increased several times, but doesn't appear to
> > help. Neither database is very busy.
> >
> > One of the databases serves as a "Gateway" database between a 7.3.4 and
> > a 9.2 database just for connectivity. The other is just a straight
> > 8.1.7 OLTP database.
> >
> > Bouncing the database ALWAYS corrects the problem for several weeks.
> >
> > Can anyone help be diagnose the problem?
> >
> > Thanks!
> > Ron
> >
> > Important Notice!!
> > If you are not the intended recipient of this e-mail message, any use, =
> > distribution or copying of the message is prohibited.
> > Please let me know immediately by return e-mail if you have received =
> > this message by mistake, then delete the e-mail message.
> > Thank you.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l