ORA-7445 [Kkmupsviewdestfro()+62] On Merge With Query Rewrite On (Doc ID 1265114.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Merge SQL command systematically fails with an ORA-7445 [kkmupsViewDestFro()+62]

Incident trace file shows:

ORA-07445: exception encountered: core dump [kkmupsViewDestFro()+62] [SIGSEGV] [ADDR:0xC0] [PC:0x16A06D4] [Address not mapped to object] []

========= Dump for incident 2602 (ORA 7445 [kkmupsViewDestFro()+62]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC0] [PC:0x16A06D4, kkmupsViewDestFro()+62] [flags: 0x0, count: 1]
.../...
----- Current SQL Statement for this session (sql_id=3hrr6wyj7qt7c) -----
MERGE INTO test2 b
USING (SELECT c.i FROM test1_v q JOIN test2 c ON q.i = c.i) a
ON (a.i = b.i)
WHEN MATCHED THEN
  UPDATE SET b.t = 3

Call Stack contains:
 ... kkmupsViewDestFro kkmupd kkmups kkqscbsr apadrv opitca ...

Trace file also shows:
query_rewrite_enabled               = true

Workarounds for <Bug:9861859> "OERI [kkmupsViewDestFro_4] from MERGE statement with join elimination" do not help to prevent the error.
In other words, this issue still reproduces after:
 SQL> alter system set "_fix_control"="7679164:OFF";
 SQL> alter system set "_optimizer_join_elimination_enabled"=false;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms