ora 4031

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Tue, 25 Jul 2000 18:07:55 +0530
Message-Id: <10569.112867@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF63D.D174B3AC
Content-Type: text/plain;

charset="iso-8859-1"

I have suddenly started experiencing this error on my dev database

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","STANDARD","PL/SQL MPCODE",
"BAMIMA: Bam Buffer")

This is 816 on Sun. Is this a case of excessive fragmentation in the shared pool? Or is the shared pool itself too small.

Babu Nagarajan
i-Flex, Bangalore
#91-80-5597600-3381

------_=_NextPart_001_01BFF63D.D174B3AC
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=984403412-25072000>Hi</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=984403412-25072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=984403412-25072000>I have
suddenly started experiencing this error on my dev database</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=984403412-25072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=984403412-25072000>ORA-04031:
unable to allocate 4096 bytes of shared memory ("shared pool","STANDARD","PL/SQL MPCODE",<BR>"BAMIMA: Bam Buffer")</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=984403412-25072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=984403412-25072000>This is 816
on Sun. Is this a case of excessive fragmentation in the shared pool? Or is the shared pool itself too small.</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=984403412-25072000></SPAN></FONT> </DIV>
<DIV><EM><FONT color=#0000ff size=2>Babu Nagarajan</FONT></EM></DIV>
<DIV><EM><FONT color=#0000ff size=2>i-Flex, Bangalore</FONT></EM></DIV>
<DIV><FONT color=#0000ff size=2><EM>#91-80-5597600-3381</EM></FONT></DIV>
<DIV> </DIV></BODY></HTML>
Received on Tue Jul 25 2000 - 07:37:55 CDT