ORA-00600: [qksvcGetGuardCol:2] Occurs When SQL Analyze is Run on Empty Schema
Last updated on MAY 24, 2018
Applies to:Oracle Database - Standard Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
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], , , , , , , , , , , 
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
The schema is to be removed and the objects belonging to it have been dropped prior to the removal.
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