[Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-08
Medium Priority
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,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

These errors are very frequent now.

How to resolve this


Suresh Bansal

Question by:suresh_bansal
LVL 24

Accepted Solution

johanntagle earned 2000 total points
ID: 35715414

Author Closing Comment

ID: 35717969

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

Suresh Bansal

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month20 days, 10 hours left to enroll

867 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