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,
  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:
<blockquote TYPE=CITE> <span

class=984403412-25072000>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")<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.Babu Nagarajani-Flex, Bangalore#91-80-5597600-3381 </blockquote>
</html>
Received on Wed Jul 26 2000 - 04:54:32 CDT