AE Jobs or Objects stuck in Generating, bad performance

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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_plans
optimizer_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_plans to FALSE
Set optimizer_adaptive_statistics to FALSE