My Oracle Support Banner

ORA-600 [kclcls_2] Error While Gathering Statistics (Doc ID 2878633.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Following errors reported when gathering stats.

begin
  dbms_stats.unlock_table_stats('SCOTT', 'TESTTABLE');
  DBMS_STATS.GATHER_TABLE_STATS(ownname => 'SCOTT', tabname => 'TESTTABLE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => true, degree => DBMS_STATS.DEFAULT_DEGREE);
  dbms_stats.lock_table_stats('SCOTT', 'TESTTABLE');
end
________________________________________
ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query server P008, instance testinstance3 (3)
ORA-00600: internal error code, arguments: [kclcls_2], [78], [998186], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40027
ORA-06512: at "SYS.DBMS_STATS", line 38960
ORA-06512: at "SYS.DBMS_STATS", line 38069
ORA-06512: at "SYS.DBMS_STATS", line 37135
ORA-06512: at "SYS.DBMS_STATS", line 35017
ORA-06512: at "SYS.DBMS_STATS", line 34997
ORA-06512: at "SYS.DBMS_STATS", line 36699
ORA-06512: at "SYS.DBMS_STATS", line 38023
ORA-06512: at "SYS.DBMS_STATS", line 38642
ORA-06512: at "SYS.DBMS_STATS", line 39786
ORA-06512: at "SYS.DBMS_STATS", line 40231
ORA-06512: at "SYS.DBMS_STATS", line 40780
ORA-06512: at line 3

Changes

 The error, ORA-00600 [kclcls_2] [78] [998186], was observed after patching the db from 19.14 to 19.15.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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