Re: BAMIMA Bam ?

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1997/06/04
Message-ID: <5n2h8h$9r2$1@wyrm.its.uow.edu.au>#1/1

In article <338EF139.5B7B_at_sofiter.atlink.it> Roberto Finelli, robertof_at_sofiter.atlink.it writes:
>I got this *strange* error running a PL/SQL package :
>------
>ERROR at line 1:
>ORA-04031: unable to allocate 97176 bytes of shared memory ("unknown
>object","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>------
>Does anyone know what it means BAMIMA Bam ?

Shared pool (where various shared objects are kept). Speak to your DBA. They need to identify large SGA objects (usually packages and procedures), pin them at startup, and maybe also enlarge the shared pool, if that's possible.  

---

Copyright 1997 Phil Herring. This article may not be reproduced for profit.

---

Received on Wed Jun 04 1997 - 00:00:00 CDT