RE: Metalink Note 330239.1

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Fri, 12 Jan 2007 08:09:42 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E27D6@NT15.oneneck.corp>

I can confirm the last line of the note:

"In 10.2.0.2, the threshold is increased to 50MB after regression tests, so this should be a reasonable and recommended value."

I've been running 10.2.0.2 on AIX 5.3 for 7 months now and have never seen this error. I just checked the parameter and it is indeed set to 50M:

NAME                                DESCRIPTION

SYSTEM_VALUE

---

---

---

_kgl_large_heap_warning_threshold maximum heap size before KGL writes warnings to the alert log 52428800

I haven't had any problems with this database, so I would agree that 50M seems to be reasonable and safe based on my limited observations.

Regards,
Brandon  

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 12 2007 - 09:09:42 CST