ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not mapped to ob

這個報錯其實跟上一篇的ORA-00600是連在一起的，當時只顧著看600了，等7445再次報出來才發現這也是一個BUG。這個錯誤的 ML:462440.1，是一個未公開的BUG，BUG ID:4085252。這樣的錯誤也沒太多可分析和學習的，轉貼下ML的文件玩完吧。[@more@]
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3.0
This problem can occur on any platform.
Symptoms

The following errors are encountered:

ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not
mapped to object] [0x00000003C] [] []
ORA-00600: internal error code, arguments: [729], [96], [space leak], [], [], [], [], []

The call stack from the trace file contains:

killpg kksIsNLSEqual kksauc kksCheckCriteria kksCheckCursor kksSearchChildList kksfbc kkspsc0
kksParseCursor
Cause

The cause of this problem has been identified and verified in unpublished Bug 4085252.

Space leak is the primary cause of this problem.
Solution

Set EVENT 10262 to safely ignore the space leak error:

a. Set the following event in init.ora parameter file. This example disables reporting for space leaks less than 90000 bytes:

event = "10262 trace name context forever, level 90000"

b. Stop and restart the database.

If the level is set to 1, space leak checking is disabled. This is not advised because large memory leaks will be missed.

If the event is set to a value greater than 1, any space leak up to the number specified in the event is ignored.