Re: Help with error

I got this same message a few months back. You are running out of space in the shared pool, or to be precise, Oracle cannot find a large enough contigious block size to perform your action

For me, shutting down and restarting the database worked fine. Flushing the shared pool does not necessarily work and may worsen the problem.

Ideally, you will need to change a few parameters in init.ora. Also, pinning large and heavily used packages in the shared pool will help. Search metalink.oracle.com for ORA-04031 and Bam Buffer, you will get many solutions.

M

penpendisarapen_at_yahoo.com (Victor) wrote in message news:<e203374a.0206101416.466769e9_at_posting.google.com>...
> 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
Received on Tue Jun 11 2002 - 04:43:26 CDT