of course you need enough memory to increase the shared pool, and leave
something for the operating system
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:BLdN8.155929$cQ3.4816_at_sccrnsc01...
> You need a larger shared pool. In the init.ora file shared_pool_size=
You
> have tostop and restart the database for it to take effect.
> Jim
> "Victor" <penpendisarapen_at_yahoo.com> wrote in message
> news:e203374a.0206101650.1699564f_at_posting.google.com...
> > Help!
> >
> > I received the following message while doing an update:
> >
> > ERROR at line 1:
> > ORA-04045: errors during recompilation/revalidation of
> > ELSC_TEST.SET_BOM_MOD_DATE
> > ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> > pool","update bom_detail
> > set topic_...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
> >
> > I've also received something similar when doing a "CREATE OR REPLACE
> > TRIGGER" statement, and once in a while when logging in to sqlplus. We
> > have a part-time DBA who I haven't been able to contact.
> >
> > Any thoughts? Thanks in advance.
> >
> > Victor
>
>
Received on Mon Jun 10 2002 - 22:17:28 CDT
