RE: ora 4031

Hi Sarah

I managed to do just the same.. One of our process was unnecessarily pinning packages and once that was removed it has become okay.. But I also happened to change a couple of this along with this. I increased the session paramter and also increased the swap space... I dont know whether they also contributed towards solving the problem thopugh I dont see any direct correlation...

Any way now ora-4031 is gone now...

Babu

-----Original Message-----
From: Sarah Satterthwaite [mailto:ssattert_at_earthlink.net] Sent: Saturday, July 29, 2000 10:14 PM
To: Multiple recipients of list ORACLE-L Subject: 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
>

-- 
Author: Sarah Satterthwaite
  INET: ssattert_at_earthlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).