AE Jobs or Objects stuck in Generating, bad performance

Document ID : KB000120610
Last Modified Date : 08/11/2018
Show Technical Document Details
Issue:
The AE show slowness and performance degradation issues with the following error appearing in the WP logs:

ORA-00600: internal error code, arguments: [ktsbnew:objdchk_kcbnew_3]

The issue sometimes accompagnied by Jobs and Objects stuck in Generating
 
Environment:
Oracle DB version 12.1.0.2 or 12.2 and higher
So far we have only seen this behavior on an Oracle instance installed on an Exadata machine
Cause:
In Oracle 12.1.0.2 the two following variables are introduced:

optimizer_adaptive_plan
optimize_adaptive_statistics

The default value is TRUE. It is possible that the variable is not set in the PDB but is inherited from the CDB.
Resolution:
Solution :

In Oracle make the following changes:
Set optimizer_adaptive_plan to FALSE
Set optimize_adaptive_statistics to FALSE