flush shared pool n try..!!
I have tried this and worked just y'day.
Alter system flush shared_pool;
Try n let me know..
On Thu, 3 Mar 2005 18:55:57 +0000, Jared Still <jkstill@(protected):
> 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@(protected):
> > 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