RE: ora 4031

From: Kamalakannan, D (CAP, GCF) <D.Kamalakannan_at_gecapital.com>
Date: Tue, 1 Aug 2000 11:35:20 +0200
Message-Id: <10576.113459@fatcity.com>

HI this is for Solaris ,

mkfile SIZEm /swap.file where SIZE is double the amount of new physical RAM in MB
swap -a /swap.file
Create /etc/rc2.d/S99swap with step #2 in it

regards,
Kamal

-----Original Message-----
From: babu.nagarajan_at_mail.iflexsolutions.com [mailto:babu.nagarajan_at_mail.iflexsolutions.com] Sent: Tuesday, August 01, 2000 7:14 AM
To: Multiple recipients of list ORACLE-L Subject: RE: ora 4031

Hi Siva

It depends on your platform. Try swap -a...

Babu

-----Original Message-----
From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Monday, July 31, 2000 4:48 PM
To: Multiple recipients of list ORACLE-L Subject: RE: ora 4031

Hi,
How to increase the swap space.

Regards
Siva

From:
babu.nagarajan_at_mail.iflexsolutions.com[SMTP:babu.nagarajan_at_mail.iflexsolutio ns.com]
Reply To: ORACLE-L_at_fatcity.com
Sent: Monday, July 31, 2000 3:14 PM

To:     Multiple recipients of list ORACLE-L 
Subject:        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-----
Sent: Saturday, July 29, 2000 10:14 PM
To: Multiple recipients of list ORACLE-L

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). 
-- 
Author: 
  INET: babu.nagarajan_at_mail.iflexsolutions.com 

	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

Received on Tue Aug 01 2000 - 04:35:20 CDT