ORA-00600 [qesmmCChgWAReq2] Generated By JOIN Query
Last updated on FEBRUARY 21, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
ORA-00600: internal error code, arguments : [qesmmCChgWAReq2],  - generated by a complex query using Join for multiple tables.
Changing the problematic sql statement to use UNION instead of JOIN will not generate the error.
Each session that raises the error share one particularity : session cursor with flag FETCH=1; This means that the sql statement that generated the error is blocked on retrieving data from INDEX.
Analyzing the tables to check for table/index mismatches and/or corruptions don't raise any error, but hang.
Rebuilding online the indexes of the tables involved does not resolve the problem.
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