ORA-00600: [qksvcGetGuardCol:2] Occurs When SQL Analyze is Run on Empty Schema
(Doc ID 2389148.1)
Last updated on AUGUST 04, 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!