BAMIMA:Bam Buffer

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Fri, 19 Dec 2003 16:50:13 +1100
Message-ID: <SgwEb.111$g21.3792@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?

Regards Received on Thu Dec 18 2003 - 23:50:13 CST