ORA-00600: [kkmupsViewDestFro_4] - Merge command fails
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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 126.96.36.199 and was not recognized wit earlier releases.
The resultant trace file confirms:
kkmupsViewDestFro kkmupd kkmups opiprsdml opiprsdmlcb ...
: kkmupsViewDestFro [SQL_Semantic]<-- Signaling
: kkmupd [SQL_Semantic]
: kkmups [SQL_Semantic]
: opiprsdml 
: opiprsdmlcb 
: kkqcttcalo [SQL_Transform]
: kkqctdrvIT [SQL_Transform]
: apadrv [SQL_APA]
: opitca 
: kksFullTypeCheck [cursor]
: rpiswu2 
: kksLoadChild [cursor]
: kxsGetRuntimeLock [cursor]
: kksfbc [cursor]
: kkspbd0 [cursor]
: 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 188.8.131.52
alter session set optimizer_features_enable='184.108.40.206' ;
-- On 220.127.116.11
alter session set optimizer_features_enable='18.104.22.168' ;
The database was upgraded to any of the following RDBMS releases 22.214.171.124 / 126.96.36.199 / 188.8.131.52.
The problem was not seen with earlier releases such as 184.108.40.206.
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