Re: Memory Notification: Library Cache Object loaded into SGA

I'd always favour default behaviour over custom, unless shown otherwise compress=y etc , so I'd remove.

On 20/05/2008, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> In 10g Release 1 I set this parameter to fix the problem below.
>
> sql>alter system set "_kgl_large_heap_warning_threshold"=8388608
> scope=spfile ;
>
> Memory Notification: Library Cache Object loaded into SGAHeap size 14278K
> exceeds notification threshold (8192K)
>
> As you can now see in 10.2.0.3.0 it has exceeded 8192K and is
> complainingabout 14278k.
>
> Oracle has stated ( DocID: 330239.1 ) that the parameter defaults to 50M
> 10.2.0.2.0.
>
> My database is 10.2.0.3.0. What is the best way to reset this parameter?
>
> Use an alter statement and set to 50M or delete the parameter from the pfile
> andreset the instance?
> thanks.
>
> _________________________________________________________________
> E-mail for the greater good. Join the i'm Initiative from Microsoft.
> http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l