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 4031

Re: ora 4031

From: bharanidharan <t.bharanidharan_at_tatainfotech.com>
Date: Wed, 26 Jul 2000 15:24:32 +0530
Message-Id: <10570.112985@fatcity.com>

--------------9430CC6B0FDFB38267396631
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hi,
 this is b'cos of ur shared pool size is too small and it cannot accomadate large transactions at that particular time. u have to tune ur shared_pool_size along with that please check whether other SGA parameters are also OK

bharanidharan
babu.nagarajan_at_mail.iflexsolutions.com wrote:

>  HiI have suddenly started experiencing this error on my dev
> databaseORA-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 Nagarajani-Flex, Bangalore#91-80-5597600-3381

--------------9430CC6B0FDFB38267396631

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

hi,
<br>&nbsp;this is b'cos of ur shared pool size is too small and it cannot
accomadate large transactions at that particular time. u have to tune ur shared_pool_size along with that please check whether other SGA parameters are also OK
<br>&nbsp;
<p>bharanidharan
<br>babu.nagarajan_at_mail.iflexsolutions.com wrote:
<blockquote TYPE=CITE>&nbsp;<span

class=984403412-25072000><font face="Book Antiqua"><font size=-1>Hi</font></font></span><span class=984403412-25072000></span><span class=984403412-25072000><font face="Book Antiqua"><font size=-1>I have suddenly started experiencing this error on my dev database</font></font></span><span class=984403412-25072000></span><span class=984403412-25072000><font face="Book Antiqua"><font size=-1>ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","STANDARD","PL/SQL MPCODE",</font></font>
<br><font face="Book Antiqua"><font size=-1>"BAMIMA: Bam Buffer")</font></font></span><span
class=984403412-25072000></span><span class=984403412-25072000><font face="Book Antiqua"><font size=-1>This is 816 on Sun. Is this a case of excessive fragmentation in the shared pool? Or is the shared pool itself too small.</font></font></span><span class=984403412-25072000></span><i><font color="#0000FF"><font size=-1>Babu Nagarajan</font></font></i><i><font color="#0000FF"><font size=-1>i-Flex, Bangalore</font></font></i><i><font color="#0000FF"><font size=-1>#91-80-5597600-3381</font></font></i>&nbsp;</blockquote>
</html>
Received on Wed Jul 26 2000 - 04:54:32 CDT

Original text of this message

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