| Heap size exceeds warning notification in alert.log [message #441342] |
Sat, 30 January 2010 23:46  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Dear All,
i got memory notification in alertlog like
Sun Jan 31 08:35:23 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 33073K exceeds notification threshold (8192K)
what to do, please advice me. urgent pls.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Heap size exceeds warning notification in alert.log [message #441362 is a reply to message #441360] |
Sun, 31 January 2010 01:08  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Mr.Micheal
really i did necessary steps,
before it was 2mb, the i change to 8mb
but still the heap size values increasing
like..................
Memory Notification: Library Cache Object loaded into SGA
Heap size 34410K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:58:04 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34414K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:58:21 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34418K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:58:28 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34422K exceeds notification threshold (8192K)
Details in trace file /u01/app/oracle/admin/ibk/bdump/ibk_mmon_15818.trc
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:58:51 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34427K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:59:07 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34431K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:59:22 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34435K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:59:28 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34439K exceeds notification threshold (8192K)
Details in trace file /u01/app/oracle/admin/ibk/bdump/ibk_mmon_15818.trc
KGL object name :SYS.ALERT_QUE
Sun Jan 31 09:59:52 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34443K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
Sun Jan 31 10:00:07 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 34447K exceeds notification threshold (8192K)
KGL object name :SYS.ALERT_QUE
could i set this _kgl_large_heap_warning_threshold value upto 50 Mb
but it is keep on increasing, so what will be the exact solution
please advice me.
thanks
|
|
|
|
|
|
| Re: Heap size exceeds warning notification in alert.log [message #441364 is a reply to message #441362] |
Sun, 31 January 2010 01:24 |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Quote:Memory Notification: Library Cache Object loaded into SGA
Heap size 6237K exceeds notification threshold (2048K)
These are warning messages only which should not cause any problems. These warning messages appear due to new event messaging mechanism and memory manager in 10g Release 2. In 10g R2 we have a new undocumented parameter that sets the KGL heap size warning threshold. Warnings are written if heap size exceeds this threshold.
Set _kgl_large_heap_warning_threshold to a reasonable high value to prevent these warning messages: Default Threshold in 10.2.0.1 is 2 MB only. But Default Threshold value in 10.2.0.2 is 50 MB which is reasonable and recommended value.
Solution:
SQL> alter system set "_kgl_large_heap_warning_threshold"= 52428800 scope=spfile;
SQL> shutdown immediate;
SQL> startup;
i found the above at http://onlineappsdba.com/index.php/2008/03/10/errors-in-alert-log-file-of-10201-instances/
sriram 
[Updated on: Sun, 31 January 2010 01:33] Report message to a moderator |
|
|
|
| Re: Heap size exceeds warning notification in alert.log [message #441365 is a reply to message #441364] |
Sun, 31 January 2010 01:38 |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Thanks :Sriram,Micheal
Sriram i read that 50m value already, but in my case it is keep on incresing, thats why...
anyway as Micheal wrote, we can set it any value (2 GB)
thanks
i just now installed oracle and import some schema to this new DB. but in OEM showing 40 % full of dump area
how to rediuse the dump area size, please advice me.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
