On Thu, 3 Mar 2005 18:55:57 +0000, Jared Still <jkstill@(protected)> 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@(protected)> wrote: > > I have a couple of unrelated Oracle 8.1.7 databases that occasionally > > getting the following error: > > ORA-04031 (See ORA-04031.ora-code.com): 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
