Re: Help with error

Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3D055893.2CA4C112_at_exesolutions.com>...
> 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

I reset the shared_pool_size and it works fine now.

Where would I find the alert logs? We have a part-time DBA who is supposed to do maintenance just a couple of hours a week, but I haven't been able to get hold of him. I don't know if he checks this.

Victor Received on Tue Jun 11 2002 - 13:05:20 CDT