Re: Memory Notification: Library Cache Object loaded into SGA
Date: Tue, 20 May 2008 19:35:33 +0100
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
> 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?
> 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-lReceived on Tue May 20 2008 - 13:35:33 CDT