Re: PL/SQL procedures won't fit in memory
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!jrReceived on Fri Jul 26 1996 - 00:00:00 CEST