Re: Questions - Shared Pool Size and PL/SQL Packages

> We periodically get messages similar to the following when calling a
> stored procedure from our C code:
>
> ORA-04031: out of shared memory when trying to
> allocate 50212 bytes (PL/SQL MPCODE,BAMIMA:
> Grow Bam Buffer)
> ORA-06508: PL/SQL: could not find program unit
> being called
> ORA-06512: at line 1
>
We periodically get these types of messages as well, but they are related to activities associated with dbs triggers. (i.e. a commit will fail because the audit trail trigger that fired as a result of the commit fails due to lack of shared memory)

> Environment:
> Oracle V7.0.15.4.0
> PL/SQL 2.0.17.1.0
>
> Sun 4/470, SunOS 4.1.3, 64 MB memory, running two Oracle
> instances with similar init.ora parameters.
>
We are running Oracle V7.0.12.??.?? and I don't know the PL/SQL version.

We are running on a Sun 600MP, SunOS 4.1.2, 128 MB memory with one instance. I will say that the problem has decrease significantly since moving from 64 MB to 128 MB. We were seeing fairly often, now only seldom.

> Does anybody have any feedback on these items?
>

Does this help?  

> Thanks for any input/guidance you can give me.
> ---
> Dan Gaffaney Internet: dpg_at_halide.Kodak.COM
> Senior Software *ngineer (I'm NOT infringing on state licensing laws)
> Eastman Kodak Company Rochester, NY 14652-3712 (716) 722-3968
>

Alan Johnson
General Engineering Labs
Charleston ,SC
(alan_at_gel.com)
(johnsona_at_ashley.cofc.edu) Received on Fri Jun 24 1994 - 14:08:32 CEST