Re: What is "exceeds notification threshold"?

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

Relevant Pages