SGA Heap size 2273K exceeds notification thres [message #359563] |
Mon, 17 November 2008 05:26 |
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 #359660 is a reply to message #359570] |
Mon, 17 November 2008 22:29 |
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 #359722 is a reply to message #359690] |
Tue, 18 November 2008 01:25 |
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.
|
|
|
|