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@xxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l