Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-04031: unable to allocate 4200 bytes of shared memory

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

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 3 Mar 2005 18:55:57 +0000
Message-ID: <bf4638050303105546c98aa6@mail.gmail.com>


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
Received on Thu Mar 03 2005 - 13:59:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US