ORA-00600: [qksvcGetGuardCol:2] Occurs When SQL Analyze is Run on Empty Schema

(Doc ID 2389148.1)

Last updated on MAY 24, 2018

Applies to:

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

Symptoms

Automated SQL Analyze job fails with the following errors shown in the Alert.log:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_37992"
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [228771], [0], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 44764

The failing statement  shows SQL Tuning Advisor is trying to analyze a table belonging to a schema where objects were removed recently.

The error is

 

Changes

 The schema is to be removed and the objects belonging to it have been dropped prior to the removal.

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