Re: Grow BAM Buffer ?

From: Iain Bowen <alaric_at_harlech.demon.co.uk>
Date: 1997/07/13
Message-ID: <5q9nk8$3ec$1@harlech.demon.co.uk>#1/1

In article <01bc8e0b$1f10a420$707167cf_at_mattesp.voicenet.com>, Paul Mattes <mattesp_at_voicenet.com> wrote:
>*,
>Here's an interesting ermsg.... I'm pretty sure it's telling me the shared
>pool is too small, but I am interested in other opinions.
>ERROR:
>ORA-04031: out of shared memory when trying to allocate 11676 bytes (PL/SQL
>MPCO
>DE,BAMIMA: Grow Bam Buffer)

Yes, it is an "out of shared pool" message which seems to come from packages and procedures. The obvious answer is to pin the package, but that isn't always possible at a peak period.

It is also worth remembering that there may well be plenty of shared pool left, just not enough contigous memory - so it could be worth looking at splitting the code as well.

-- 
\/    Iain Bowen is alaric(at)harlech.demon.co.uk.   Red Ribbon, Blue Ribbon
   "I am not a Unix systems adminstrator, I merely play at being one at work"
  Dull Web Page: http://www.harlech.demon.co.uk/   PGP Public Key on request
       UK-VOTING web pages: http://www.harlech.demon.co.uk/ukvoting.htm

Received on Sun Jul 13 1997 - 00:00:00 CDT