OraFAQ Forum: Server Administration » SGA Heap size 2273K exceeds notification thres

Home » RDBMS Server » Server Administration » SGA Heap size 2273K exceeds notification thres (10g, windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359565 is a reply to message #359563]

Mon, 17 November 2008 05:29

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no relation between the two.

Regards
Michel

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359567 is a reply to message #359563]

Mon, 17 November 2008 05:49

hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan

Junior Member

but how to resolve this message in alter file

Hasan

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359570 is a reply to message #359567]

Mon, 17 November 2008 06:11

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

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).

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359690 is a reply to message #359660]

Tue, 18 November 2008 00:46

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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.

Report message to a moderator

Re: SGA Heap size 2273K exceeds notification thres [message #359766 is a reply to message #359660]

Tue, 18 November 2008 02:41

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:48:47 CDT 2024