Re: What is "exceeds notification threshold"?

On Jan 31, 3:34 am, Peter Teoh <htmldevelo..._at_gmail.com> 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?

It is just a warning.

From one of my previous posts:
http://download-east.oracle.com/oowsf2005/003wp.pdf Page 11: "In 10gR2 onwards, the attempted allocations of very large heaps (>2MB)
by the Library Cache are signaled in the alert log (remember that a heap is comprised of non-contiguous chunks). The following is an example of such an alert log entry:
Wed Sep 7 15:56:56 2005
Memory Notification: Library Cache Object loaded into SGA Heap size 3072K exceeds notification threshold (2048K) Details in trace file /oracle/rdbms/log/main_ora_27395.trcKGL object name :select xxx from yyy where ..."

http://laurentschneider.blogspot.com/2005/11/10201-hidden-parameters.html "_kgl_large_heap_warning_threshold=33554432 This parameter prevent Heap
size 2800K exceeds notification threshold errors in the alert log and user trace dumps.
Note: 330239.1 Bugs: 4286095, 4390265"

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Jan 31 2008 - 05:12:24 CST