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 laterInformation 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 |