Re: BAMIMA:Bam Buffer

From: Goran <goran99(remove)_at_yahoo.com>
Date: Fri, 19 Dec 2003 11:11:55 +0100
Message-ID: <bruiub$j6k$1@fegnews.vip.hr>

"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:SgwEb.111$g21.3792_at_nnrp1.ozemail.com.au...
> Version : 8.1.7.0.0
> Sun Solaris 2.8
>
> I'm getting the old BAMIMA:Bam Buffer error regularly on my database.
> I have tried pinning packages to no avail. I have also increased the size
> of the shared pool size and it is now three times the initial size (About
> 300M). All that is happening is that it is taking longer between
failures.
>
> I suspect that the application which is using the database may have a lot
of
> dynamic SQL. I'm wondering if this might be an issue as the dynamic
> statements do not have bind variables.
>
> I'm confused about the error because I thought select statements would be
> aged out rather than the shared pool run out of memory.
>
> Can anybody shed light?

Apply 81740 patchet, it should fix that.

Regards,
Goran Received on Fri Dec 19 2003 - 04:11:55 CST