AE Jobs or Objects stuck in Generating, bad performance

Document ID : KB000120610
Last Modified Date : 08/11/2018
Show Technical Document Details
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
Oracle DB version or 12.2 and higher
So far we have only seen this behavior on an Oracle instance installed on an Exadata machine
In Oracle the two following variables are introduced:


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

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