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@xxxxxxxxxxx] Sent: Tuesday, 22 June 2004 10:02 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------