Home » RDBMS Server » Performance Tuning » Heap size exceeds warning notification in alert.log (oracle 10.2.0.1.0,Redhat Linux 4.5 [Enterprise edition])
Heap size exceeds warning notification in alert.log [message #441342] Sat, 30 January 2010 23:46 Go to next message
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 #441349 is a reply to message #441342] Sat, 30 January 2010 23:57 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
see Details in your trace file ...
And also...
Check out Metalink Note 330239.1.


http://forums.oracle.com/forums/thread.jspa?threadID=317122

http://www.lazydba.com/oracle/0__129872.html


sriram Smile

[Updated on: Sat, 30 January 2010 23:58]

Report message to a moderator

Re: Heap size exceeds warning notification in alert.log [message #441350 is a reply to message #441342] Sat, 30 January 2010 23:59 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
>what to do, please advice me. urgent pls.
You can safely ignore this annoying nag-o-gram.
Re: Heap size exceeds warning notification in alert.log [message #441360 is a reply to message #441342] Sun, 31 January 2010 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/436094/102589/#msg_436094

Regards
Michel
Re: Heap size exceeds warning notification in alert.log [message #441361 is a reply to message #441360] Sun, 31 January 2010 00:44 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Just above to that http://www.orafaq.com/forum/mv/msg/153327/436089/136607/#msg_436089

Wink

So please search bofore posting.....

sriram Smile

[Updated on: Sun, 31 January 2010 00:46]

Report message to a moderator

Re: Heap size exceeds warning notification in alert.log [message #441362 is a reply to message #441360] Sun, 31 January 2010 01:08 Go to previous messageGo to next message
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 #441363 is a reply to message #441362] Sun, 31 January 2010 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can set it at any value you want it does not matter, it is just a threshold to indicate when the message is recorded in alert.log.
Set it to 2 GB.

Regards
Michel
Re: Heap size exceeds warning notification in alert.log [message #441364 is a reply to message #441362] Sun, 31 January 2010 01:24 Go to previous messageGo to next message
ramoradba
Messages: 2454
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 Smile

[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 Go to previous messageGo to next message
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.
Re: Heap size exceeds warning notification in alert.log [message #441366 is a reply to message #441365] Sun, 31 January 2010 01:41 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Another question, another topic, do not mix the questions otherwise the topic will be incomprehensible for others.

Regards
Michel

[Updated on: Sun, 31 January 2010 01:41]

Report message to a moderator

Previous Topic: slower execution of pl/sql code
Next Topic: Oracle Segment Tuning
Goto Forum:
  


Current Time: Sat Oct 01 10:58:59 CDT 2016

Total time taken to generate the page: 0.09808 seconds