Heap size 3998K exceeds notification threshold (2048K) in Oracle 10g
Dear Sir,
We are using Oracle 10g Windows 64 Bit on Windows Server 2003 64 Bit with 8GB RAM.
Things are working perfect since last two years. Now suddently we start getting following errors in the Alert.log as under
Fri May 06 10:14:25 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 3998K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_460.trc
KGL object name :select d.assmastid,a.name aname,a.acunitid,d.specs,s.msono,s.excvrsrid_msono,s.vrdate,s.partyord,s.porddate,s.masterid,m.name mname,m.add1 madd1,m.add2 madd2,city.name madd3,m.staxnol mlst,m.staxnoc mcst,m.eccode meccode,m.range mrange,m.div mdiv,s.consigid,nvl(consig.name,'As Above') cname,consig.add1 cadd1,consig.add2 cadd2,consig_city.name cadd3,consig.staxnol clst,consig.staxnoc ccst,consig.eccode ceccode,d.qty,d.rate,s.job_form,d.dldate,sc.print_side,sc.lami_side,sc.pkd_value,layer1_material.abname la
This has become very frequent may be 20-100 times in a day and this causes Hangup of the Application many times for say 2 to 30 Minutes
Pl suggest some resolution
Suresh Bansal