| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora 4031
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_01BFFB73.5D1DF65E
Content-Type: text/plain;
charset="iso-8859-1"
Hi Siva
It depends on your platform. Try swap -a...
Babu
-----Original Message-----
From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com]
Sent: Monday, July 31, 2000 4:48 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ora 4031
Hi,
How to increase the swap space.
Regards
Siva
To: Multiple recipients of list ORACLE-L Subject: RE: ora 4031 Hi Sarah I managed to do just the same.. One of our process was unnecessarilypinning
and also increased the swap space... I dont know whether they also contributed towards solving the problem thopugh I dont see any direct correlation...
Any way now ora-4031 is gone now...
Babu
-----Original Message-----
Sent: Saturday, July 29, 2000 10:14 PM
To: Multiple recipients of list ORACLE-L
Babu,
We started getting these last week when testing some new code on a
7.3.4
database. Go to metalink and search under technical bullittens for ora-4031
(note 61623.1--I think). I have also found some good information in Richard
Neimic's (TUSC) book on Tuning. Steve Adam's book on Oracle Internals and his web site had some useful scripts also (www.ixora.com.au). We made both the shared pool and the reserved pool larger and ended up unpinning a lot of
application packages that had been pinned for the last year or more--and then the errors stopped. I am trying to figure out how to predict how much memory things are going to need...
Good luck.
Sarah Satterthwaite
Database Administrator
Case Shiller Weiss, Inc
Cambridge, MA
> babu.nagarajan_at_mail.iflexsolutions.com wrote:
>
> Hi
>
> 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
>
--
Author: Sarah Satterthwaite
INET: ssattert_at_earthlink.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Author:
INET: babu.nagarajan_at_mail.iflexsolutions.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
------_=_NextPart_001_01BFFB73.5D1DF65E
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">
<TITLE>RE: ora 4031</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=246314704-01082000>Hi
Siva</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=246314704-01082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=246314704-01082000>It
depends on your platform. Try swap -a...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=246314704-01082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=246314704-01082000>Babu</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Siva_Chintalapati
[mailto:Siva_Chintalapati_at_satyam.com]<BR><B>Sent:</B> Monday, July 31, 2000
4:48 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
RE: ora 4031<BR><BR></DIV></FONT>
<P><FONT color=#0000ff face=Arial size=2>Hi,</FONT> <BR><FONT color=#0000ff
face=Arial size=2>How to increase the swap space.</FONT> </P>
<P><FONT color=#0000ff face=Arial size=2>Regards</FONT> <BR><FONT
color=#0000ff face=Arial size=2>Siva</FONT> </P>
<UL>
<P><FONT face="MS Sans Serif" size=1>----------</FONT> <BR><B><FONT
face="MS Sans Serif" size=1>From:</FONT></B> <FONT
face="MS Sans Serif"
size=1>babu.nagarajan_at_mail.iflexsolutions.com[SMTP:babu.nagarajan_at_mail.iflexsolutions.com]</FONT>
<BR><B><FONT face="MS Sans Serif" size=1>Reply To:</FONT></B>
<FONT face="MS Sans Serif"
size=1>ORACLE-L_at_fatcity.com</FONT> <BR><B><FONT face="MS Sans Serif"
size=1>Sent:</FONT></B> <FONT face="MS Sans Serif" size=1>Monday,
July 31, 2000 3:14 PM</FONT> <BR><B><FONT face="MS Sans Serif"
size=1>To:</FONT></B> <FONT face="MS Sans Serif"
size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT
face="MS Sans Serif" size=1>Subject:</FONT></B>
<FONT face="MS Sans Serif" size=1>RE:
ora 4031</FONT> </P>
<P><FONT face=Arial size=2>Hi Sarah</FONT> </P>
<P><FONT face=Arial size=2>I managed to do just the same.. One of our
process was unnecessarily pinning</FONT> <BR><FONT face=Arial
size=2>packages and once that was removed it has become okay.. But I also
happened</FONT> <BR><FONT face=Arial size=2>to change a couple of this along
with this. I increased the session paramter</FONT> <BR><FONT face=Arial
size=2>and also increased the swap space... I dont know whether they
also</FONT> <BR><FONT face=Arial size=2>contributed towards solving the
problem thopugh I dont see any direct</FONT> <BR><FONT face=Arial
size=2>correlation...</FONT> </P>
<P><FONT face=Arial size=2>Any way now ora-4031 is gone now...</FONT> </P>
<P><FONT face=Arial size=2>Babu</FONT> </P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT> <BR><FONT
face=Arial size=2>Sent: Saturday, July 29, 2000 10:14 PM</FONT> <BR><FONT
face=Arial size=2>To: Multiple recipients of list ORACLE-L</FONT> </P><BR>
<P><FONT face=Arial size=2>Babu,</FONT> </P>
<P><FONT face=Arial size=2>We started getting these last week when testing
some new code on a 7.3.4</FONT> <BR><FONT face=Arial size=2>database.
Go to metalink and search under technical bullittens for ora-4031</FONT>
<BR><FONT face=Arial size=2>(note 61623.1--I think). I have also found
some good information in Richard</FONT> <BR><FONT face=Arial size=2>Neimic's
(TUSC) book on Tuning. Steve Adam's book on Oracle Internals and</FONT>
<BR><FONT face=Arial size=2>his web site had some useful scripts also
(www.ixora.com.au). We made both</FONT> <BR><FONT face=Arial
size=2>the shared pool and the reserved pool larger and ended up unpinning a
lot of</FONT> <BR><FONT face=Arial size=2>application packages that had been
pinned for the last year or more--and</FONT> <BR><FONT face=Arial
size=2>then the errors stopped. I am trying to figure out how to
predict how much</FONT> <BR><FONT face=Arial size=2>memory things are going
to need...</FONT> </P>
<P><FONT face=Arial size=2>Good luck.</FONT> </P>
<P><FONT face=Arial size=2>Sarah Satterthwaite</FONT> <BR><FONT face=Arial
size=2>Database Administrator</FONT> <BR><FONT face=Arial size=2>Case
Shiller Weiss, Inc</FONT> <BR><FONT face=Arial size=2>Cambridge, MA</FONT>
</P>
<P><FONT face=Arial size=2>> babu.nagarajan_at_mail.iflexsolutions.com
wrote:</FONT> <BR><FONT face=Arial size=2>> </FONT><BR><FONT face=Arial
size=2>> Hi</FONT> <BR><FONT face=Arial size=2>> </FONT><BR><FONT
face=Arial size=2>> I have suddenly started experiencing this error on my
dev database</FONT> <BR><FONT face=Arial size=2>> </FONT><BR><FONT
face=Arial size=2>> ORA-04031: unable to allocate 4096 bytes of shared
memory ("shared</FONT> <BR><FONT face=Arial size=2>pool","STANDARD","PL/SQL
MPCODE",</FONT> <BR><FONT face=Arial size=2>> "BAMIMA: Bam
Buffer")</FONT> <BR><FONT face=Arial size=2>> </FONT><BR><FONT face=Arial
size=2>> This is 816 on Sun. Is this a case of excessive fragmentation in
the</FONT> <BR><FONT face=Arial size=2>shared pool? Or is the shared pool
itself too small.</FONT> <BR><FONT face=Arial size=2>> </FONT><BR><FONT
face=Arial size=2>> Babu Nagarajan</FONT> <BR><FONT face=Arial
size=2>> i-Flex, Bangalore</FONT> <BR><FONT face=Arial size=2>>
#91-80-5597600-3381</FONT> <BR><FONT face=Arial size=2>></FONT> <BR><FONT
face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Author: Sarah
Satterthwaite</FONT> <BR><FONT face=Arial size=2> INET:
ssattert_at_earthlink.net</FONT> </P>
<P><FONT face=Arial size=2>Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists</FONT> <BR><FONT face=Arial
size=2>--------------------------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send
an E-Mail message</FONT> <BR><FONT face=Arial size=2>to:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT face=Arial size=2>the message BODY, include a line containing:
UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the name of mailing
list you want to be removed from). You may</FONT> <BR><FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).</FONT> <BR><FONT face=Arial size=2>-- </FONT><BR><FONT
face=Arial size=2>Author: </FONT><BR><FONT face=Arial size=2> INET:
babu.nagarajan_at_mail.iflexsolutions.com</FONT> </P>
<P><FONT face=Arial size=2>Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists</FONT> <BR><FONT face=Arial
size=2>--------------------------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send
an E-Mail message</FONT> <BR><FONT face=Arial size=2>to:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT face=Arial size=2>the message BODY, include a line containing:
UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the name of mailing
list you want to be removed from). You may</FONT> <BR><FONT face=Arial
Received on Mon Jul 31 2000 - 23:47:58 CDT
 |
 |