Message-Id: <10570.112985@fatcity.com> From: bharanidharan Date: Wed, 26 Jul 2000 15:24:32 +0530 Subject: Re: ora 4031 --------------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@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 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@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