ORA-00600 [qesmmCChgWAReq2] Generated By JOIN Query

(Doc ID 2359255.1)

Last updated on FEBRUARY 21, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ORA-00600: internal error code, arguments : [qesmmCChgWAReq2], [2]  -  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.

Main Stack:

 

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