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

From: Jaap Reijm <jr_at_foxim.nl>
Date: 1996/07/26
Message-ID: <4t9ogd$649_at_foxim.nl>#1/1


Paul Young (youngpa_at_statcan.ca) 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 #
: ################################################################

Oracle's shared memory pool became so fragmented that he couldn't find a contigues piece of it to fit your program unit. Increase the size of your shared_pool or flush it using the alter system flush shared_pool command and try again.

Good luck

-- 
Jaap Reijm, software engineer at Foxim Software, Rotterdam, Netherlands,
tel: 010-4557411, fax: 010-4201783, Internet: jr_at_foxim.nl
				    ARPA: ...!uunet!mcsun!sun4nl!foxim!jr
Received on Fri Jul 26 1996 - 00:00:00 CEST

Original text of this message