Home » RDBMS Server » Server Administration » SGA Heap size 2273K exceeds notification thres (10g, windows 2003)
SGA Heap size 2273K exceeds notification thres [message #359563] Mon, 17 November 2008 05:26 Go to next message
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
Junior Member
i got this message in alterfile
i m using 10g version 2

Memory Notification: Library Cache Object loaded into SGA Heap
size 2273K exceeds notification threshold (2048K)

and all queries hangsup.

please guide me how to solve this..

Regards

Hasan
Re: SGA Heap size 2273K exceeds notification thres [message #359565 is a reply to message #359563] Mon, 17 November 2008 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no relation between the two.

Regards
Michel
Re: SGA Heap size 2273K exceeds notification thres [message #359567 is a reply to message #359563] Mon, 17 November 2008 05:49 Go to previous messageGo to next message
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
Junior Member
but how to resolve this message in alter file


Hasan
Re: SGA Heap size 2273K exceeds notification thres [message #359570 is a reply to message #359567] Mon, 17 November 2008 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is just an informative message you can ignore it.
If you have a Metalink account, search for this message on it, a note gives a hidden parameter to change the threshold.

Regards
Michel

[Updated on: Mon, 17 November 2008 06:12]

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359660 is a reply to message #359570] Mon, 17 November 2008 22:29 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
sys@META> SELECT a.ksppinm "Parameter", b.ksppstvl "Session Value",
  2         c.ksppstvl "Instance Value"
  3    FROM x$ksppi a, x$ksppcv b, x$ksppsv c
  4   WHERE a.indx = b.indx AND a.indx = c.indx
  5         AND a.ksppinm LIKE '%kgl_large_heap%';

Parameter
--------------------------------------------------------------------------------

Session Value
--------------------------------------------------------------------------------
--------------------
Instance Value
--------------------------------------------------------------------------------
--------------------
_kgl_large_heap_warning_threshold
52428800
52428800

sys@META>



You can change the undocumented parameter _kg_large_heap_warning_threshold by 20,30,50MB

sys@META>alter system set 
   2     _kg_large_heap_warning_threshold=52428800
   3     scope=spfile;


And restart database to apply it's value.
The Oracle Database Enterprise with Patchset 10.2.0.3/4 fixed it (default value=50MB).
Re: SGA Heap size 2273K exceeds notification thres [message #359690 is a reply to message #359660] Tue, 18 November 2008 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DO NOT post hidden parameters unless you can explain IN DEEP AND DETAILS what are ALL the consequences of it and are ready to pay if they do any harm.

Are you from Oracle and can certify that will not lead to any problem in anyone's database?

Regards
Michel
Re: SGA Heap size 2273K exceeds notification thres [message #359722 is a reply to message #359690] Tue, 18 November 2008 01:25 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I am sorry, Michel!

Since the java object which has been cached in our production some time fall out, and the OC4J - opmn.log returned problem "out of process memory..", and I got that error in alert_SID.log. Searched, read and tested with increasing _kg's value, I've fixed it. And I though, someone may got it like me.

Of course, so much thing need to be explained.

And I do not come from Oracle.

So that, I will not post undocumented parameters like in the future.
Re: SGA Heap size 2273K exceeds notification thres [message #359766 is a reply to message #359660] Tue, 18 November 2008 02:41 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

trantuananh24hg wrote on Tue, 18 November 2008 05:29
The Oracle Database Enterprise with Patchset 10.2.0.3/4 fixed it (default value=50MB).


Actually, it was fixed in 10.2.0.2

Previous Topic: Segment Advisor report
Next Topic: User wihtout Create user command
Goto Forum:
  


Current Time: Fri Nov 29 18:52:51 CST 2024