Re: PL/SQL procedures won't fit in memory

I have run into the same problem. I have not confirmed this with anyone but I believe that the shared memory pool is getting fragmented. Under Oracle 7.1, PL/SQL must load into contiguous memory chunk. To fix, I increased my shared pool size. I understand 7.2 (or maybe its 7.3) overcomes this problem by allowing PL/SQL to load and run in non-contiguous memory.

Good luck and let me know if you get an answer!

Scott

Paul Young wrote:
>
> We've been using PL/SQL more and more in our application development.
> I believe we've hit some kind of limit though. We have some fairly large
> procedures and sometimes they just don't run. Sometimes they do.
>
> It seems that when the system is busier, they fail. The error I receive
> is:
>
> DECLARE
> *
> ERROR at line 1:
> ORA-04031: unable to allocate 86184 bytes of shared memory ("IMP_RE_FVAR1","PL/S
> QL MPCODE","BAMIMA: Grow Bam Buffer")
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 93
>
> Oracle Versions on HP Unix UX10:
> Oracle7 Server Release 7.1.6.2.0 - Production Release
> PL/SQL Release 2.1.6.2.0 - Production
>
> Have you ever received and worked around this problem. Please E-mail a
> response. Many thanks in advance.
>
> PGY (Opinions expressed are mine and mine alone)
> ################################################################
> # Paul Young #
> # youngpa_at_statcan.ca #
> # Statistics Canada #
> ################################################################
Received on Sat Jul 20 1996 - 00:00:00 CEST