Re: What is "exceeds notification threshold"?

On Thu, 31 Jan 2008 00:34:02 -0800, Peter Teoh wrote:

> My alert.log showed the following:
>
>
> Completed: ALTER DATABASE OPEN
> Thu Jan 31 13:57:36 2008
> Shutting down archive processes
> Thu Jan 31 13:57:41 2008
> ARCH shutting down
> ARC2: Archival stopped
> Thu Jan 31 16:35:18 2008
> Memory Notification: Library Cache Object loaded into SGA Heap size
> 2290K exceeds notification threshold (2048K) KGL object name
> :XDB.XDbD/PLZ01TcHgNAgAIIegtw== Thu Jan 31 16:35:19 2008
> Memory Notification: Library Cache Object loaded into SGA Heap size
> 2172K exceeds notification threshold (2048K) Details in trace file
> /u01/app/oracle/admin/orcl/udump/ orcl_ora_11288.trc
> KGL object name :XDB.XD+s5hmkr05krgMFeMBRYQnQ==
>
> What is happening?

There is a hidden parameter called "_kgl_large_heap_warning_threshold" in oracle10g and oracle11g which can be set to 16Mor 32M to alleviate this problem. This parameter does not exist in oracle9i.As Charles has told you, you are dealing with a bug. Of course, you should report the problem to the technical support and not engage into fixing unsupported parameters yourself, without the instructions from Oracle Support.

-- 
http://mgogala.freehostia.com