PL/SQL procedures won't fit in memory
From: Paul Young <youngpa_at_statcan.ca>
Date: 1996/07/19
Message-ID: <Dusv7L.Juu_at_statcan.ca>#1/1
Date: 1996/07/19
Message-ID: <Dusv7L.Juu_at_statcan.ca>#1/1
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
Oracle Versions on HP Unix UX10:
*
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
Oracle7 Server Release 7.1.6.2.0 - Production Release
PL/SQL Release 2.1.6.2.0 - Production
PGY (Opinions expressed are mine and mine alone)
################################################################Received on Fri Jul 19 1996 - 00:00:00 CEST
# Paul Young #
# youngpa_at_statcan.ca #
# Statistics Canada #
################################################################