Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why am I getting "Unable to allocate memory" errors?
Ken Denny wrote:
>
> Packaged procedures in my database are frequently failing with
> ORA-04031: unable to allocate nnnnn bytes of shared memory([various
> parameters])
> I recently had my DBA increase the shared memory pool by 8 Meg but it
> doesn't appear to be helping. If anyone has any suggestions please email
> me.
>
> Thanks
> Ken Denny
> kennethd_at_nortel.com
Try flushing the SGA then recompiling - It works for me
Sj Received on Wed Feb 25 1998 - 00:00:00 CST