Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Miss Bamima

RE: Miss Bamima

From: Graeme Farmer <graeme.farmer_at_mincom.com>
Date: Tue, 22 Jun 2004 22:09:24 +1000
Message-ID: <DA5B390A2CBAA64AB2367C2EDA3210F60CA656D8@tqxbneclu03.root.tequinox.com>


means what it says. insufficient memory in shared pool. in 8.1.7 (base release) there is a bug in which fixed memory is leaked but this is usually a gradual leak exacerbated with usage over time.

in your case it is occurring on database creation i can only assume that your selection of parameters in DBCA has led to some inappropriate init.ora settings. I don't use DBCA so I have no idea what settings it is trying to use but obviously the shared pool was not large enough or became too fragmented too quickly given it's parameter selection.

cheers,
gf

-----Original Message-----

From: fahd mirza [mailto:fahd-m_at_aero.com.pk] Sent: Tuesday, 22 June 2004 10:02 PM
To: oracle-l_at_freelists.org
Subject: Miss Bamima

Hi Listers,

    Take it easy, I am not gonna introduce some DBA chick (sorry feminists..., just kidding).

    While creating a new database in 8.1.7, I received the following error.     ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","unknown object","PL/SQL MPCODE; "BAMIMA BAM BUFFER") I was creating multipurpose databse with 256 MB RAM with 500 concurrent users.I abort the process and then again created the database with just 15 concurrent users, and the Miss Bamima vanished and the database got created successfully. I am sure it has something to do with RAM. Would anybody please give some lights that what this bamima bam buffer is? thanks
regards,
Fahd    



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

--

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Limited unless expressly stated otherwise.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Jun 22 2004 - 07:11:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US