ORA-00600: [kkmupsViewDestFro_4] - Merge command fails

(Doc ID 1925035.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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


A MERGE statement fails due to ORA-00600 [kkmupsViewDestFro_4].   
The issue occurs since customer has upgraded to 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]


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
  alter session set optimizer_features_enable='' ;

  -- On
  alter session set optimizer_features_enable='' ;



Current Releaseoptimizer_features_enablestatus ORA-00600 No error ORA-00600 No error



The database was upgraded to any of the following RDBMS releases / /

The problem was not seen with earlier releases such as




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