Re: ora 4031

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
Received on Sat Jul 29 2000 - 10:40:42 CDT