ORA-00600: [kkmupsViewDestFro_4] - Merge command fails
(Doc ID 1925035.1)
Last updated on APRIL 06, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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.
Trace File
The resultant trace file confirms:
----------------
kkmupsViewDestFro kkmupd kkmups opiprsdml opiprsdmlcb ...
---------------------
[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 Release | optimizer_features_enable | status |
|---|---|---|
| 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |