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@xxxxxxxxx> 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@xxxxxxx> 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. > > -- > > //www.freelists.org/webpage/oracle-l > > > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l