From wweaver@rightnow.com Fri, 21 Sep 2001 05:31:55 -0700 From: "Weaver, Walt" Date: Fri, 21 Sep 2001 05:31:55 -0700 Subject: RE: Rash of shared memory errors Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yes, one of the reasons we upgraded to 8.1.7.2 was to fix this bug. Can't report just yet as to whether it works or not. --Walt Weaver Bozeman, Montana -----Original Message----- Sent: Friday, September 21, 2001 3:30 AM To: Multiple recipients of list ORACLE-L are you using oracle 8.1.7? if you are, this is caused by a bug on this version. you will only need to add another parameter in your init.ora... search metalink for the details of how to fix this... hth =) Arn Klammer wrote: > Hi, > > Just recently, we have been frequently receiving errors like the following in our development database: > > ERROR: > ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN > DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer") > > The size of our shared pool is not too small (I think); it's larger than our test and maintenance databases, for example. > > shared_pool_reserved_size string 800000 > shared_pool_size string 16000000 > > What could be causing this level of frequent fragmentation? We have been developing a new application in the database, but this has been ongoing for some months; the errors appeared only in the last week or so. > > What should I be looking for to solve this? > > Thanx for any advice. > > -arn > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arn Klammer > INET: Arn.Klammer@austrac.gov.au > > 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@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). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: mtdelavega@pse.org.ph 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: wweaver@rightnow.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@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).