ORA-00600: [kkmupsViewDestFro_4] - Merge command fails (Doc ID 1925035.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

A MERGE statement fails due to ORA-00600 [kkmupsViewDestFro_4].   
The issue occurs since customer has upgraded to 11.2.0.4 and was not recognized wit earlier releases.

ORA-00600: internal error code, arguments: [kkmupsViewDestFro_4], [588168], [552412], [], [], [], [], [], [], [], [], []      

 

Trace File

The resultant trace file confirms:

Call Stack Trace
----------------
kkmupsViewDestFro kkmupd kkmups opiprsdml opiprsdmlcb ...

 

Incident Context Dump
---------------------
[08]: kkmupsViewDestFro [SQL_Semantic]<-- Signaling
[09]: kkmupd [SQL_Semantic]
[10]: kkmups [SQL_Semantic]
[11]: opiprsdml []
[12]: opiprsdmlcb []
[13]: kkqcttcalo [SQL_Transform]
[14]: kkqctdrvIT [SQL_Transform]
[15]: apadrv [SQL_APA]
[16]: opitca []
[17]: kksFullTypeCheck [cursor]
[18]: rpiswu2 []
[19]: kksLoadChild [cursor]
[20]: kxsGetRuntimeLock [cursor]
[21]: kksfbc [cursor]
[22]: kkspbd0 [cursor]
[23]: kksParseCursor [cursor]

      


Reproducibility
The issue is permanently reproducible when using the optimizer features (parameter: set optimizer_features_enable) of the current release.
Problem disappears when using the optimizer features of a previous release.

Example - The issue does not reproduce when using:

  -- On 11.2.0.4
  alter session set optimizer_features_enable='11.2.0.3' ;

  -- On 12.2.0.1
  alter session set optimizer_features_enable='11.2.0.4' ;

 

Overview

Current Releaseoptimizer_features_enablestatus
11.2.0.4 11.2.0.4 ORA-00600
11.2.0.4 11.2.0.3 No error
12.1.0.1 12.1.0.1 ORA-00600
12.1.0.1 11.2.0.4 No error

 

Changes

The database was upgraded to any of the following RDBMS releases 11.2.0.4 / 12.1.0.1 / 12.1.0.2.

The problem was not seen with earlier releases such as 11.2.0.3.

 

 

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