Re: Why am I getting "Unable to allocate memory" errors?

From: venkata terala <venkata_at_inetnow.net>
Date: 1998/02/25
Message-ID: <34f4b07e.0@news.inetnow.net>#1/1

Steve,
ORA-04031 indicates your shared pool is fragmented. Even though there might be a lot of free space in the shared pool, there may not be enough contiguous free space to fit your packaged procedures. The best thing to do would be to pin those procs/packages in memory. Check out the DBMS-SHARED_POOL package. Flushing the shared pool is very often only a temporary solution.
hope that helps
Regards
venkat

>> 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