Message-Id: <10569.112867@fatcity.com> From: babu.nagarajan@mail.iflexsolutions.com Date: Tue, 25 Jul 2000 18:07:55 +0530 Subject: 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_01BFF63D.D174B3AC Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01BFF63D.D174B3AC Content-Type: text/html; charset="iso-8859-1"
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