Re: ORA-04031 - Which packages should be kept in memory?

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 25 Apr 2007 08:09:09 -0500
Message-ID: <462f46ba$0$16356$88260bb3@free.teranews.com>

Alexander Skwar wrote:
> Alexander Skwar <alexander_at_skwar.name> wrote:
>

>> I already did that. I increased the shared_pool by 40m, which nearly
>> doubled it. I did not do anything to the SHARED_POOL_RESERVED_SIZE,
>> though. I'll do that.

>
> I just increased this size as well (from ~10m by ~40m to ~50m).
>
> Didn't change anything at all.
>
> I also tried doubling the shared_pool_size from 100m to 200m. This
> also did not help.
>
> Alexander Skwar

When you query V$SGASTAT, how much 'free memory' is shown for the shared pool?

Typically (but not always), you'll need a shared pool larger than 100m. Shared pools of 200m or much larger are not uncommon in today's systems, especially if you have lots of procedural code in the database. I have some Shared Pools that are 500MB in size.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Wed Apr 25 2007 - 08:09:09 CDT