Heap size 4256K exceeds notification threshold (2048K) - Oracle 10g

Posted on 2011-05-08
Last Modified: 2012-05-11
Dear Sir,

Our Oracle server is 10g in Windows 64 Bit. It has windows 2008 64 Bit OS with 8GB RAM.

This was running perfect since last two years.

Now it is giving errors which we diagnosed in the alerts.log file  from \oracle\product\bdump folder  which is 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, aname,a.acunitid,d.specs,s.msono,s.excvrsrid_msono,s.vrdate,s.partyord,s.porddate,s.masterid, mname,m.add1 madd1,m.add2 madd2, madd3,m.staxnol mlst,m.staxnoc mcst,m.eccode meccode,m.range mrange,m.div mdiv,s.consigid,nvl(,'As Above') cname,consig.add1 cadd1,consig.add2 cadd2, 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

These errors are very frequent now.

How to resolve this


Suresh Bansal

Question by:suresh_bansal
    LVL 24

    Accepted Solution


    Author Closing Comment


    This has solved  too much warnings in the Alert.log file of Oracle

    Suresh Bansal

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
    This video shows how to recover a database from a user managed backup

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now