Re: Grow BAM Buffer ?

From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/07/14
Message-ID: <01bc90a0$ac066a80$096fc589@RSNOWDEN.labinterlink.com>#1/1

Sure looks like a fragged shared pool to me. You might not have to expand the shared pool, but you might try pinning the bigger pl/sql packages and procedures. Or, upgrade to 7.3, which tolerates shared pool fragmentation.

Roger Snowden
> 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 Received on Mon Jul 14 1997 - 00:00:00 CDT