My Oracle Support Banner

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 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], [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



 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.