Miss Bamima 2004-06-22 - By Graeme Farmer
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@(protected)]
Sent: Tuesday, 22 June 2004 10:02 PM
To: oracle-l@(protected)
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 (See ORA-04031.ora-code.com): 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
