Re: Help with error

Victor wrote:

> I've recently been receiving the following error message while running
> a SQL script that creates tables and triggers:
>
> ERROR at line 1:
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>
> This started happening a few days ago, and shows up at the part of the
> script where a couple of triggers are being created. Actually, the
> triggers have been previously loaded, but after the "CREATE or
> REPLACE..." this error appears and my previous trigger is gone. When I
> load the trigger without running the script, the trigger loads without
> an error. I also get his error message once in a while when I run
> sqlplus.
>
> Could someone tell me what's wrong? TIA
>
> Victor

I'll bet no one has looked in the alert logs since the day the database was created.

Check the alert logs

Then start tuning the initSID.ora parameters.

To learn which ones either look at the Google archives or hit one of the numerous xxx.oracle.com web sites.

Daniel Morgan Received on Mon Jun 10 2002 - 20:55:31 CDT