dbms_stats.gather_schema_stats - ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query

by kevin   Last Updated June 13, 2019 09:06 AM

We are getting ORA-600 while stat collection, DB - Oracle 12.2 (CDB/PDB) OS - RHEL

exec dbms_stats.gather_schema_stats('MYSCHEMA', options => 'GATHER AUTO');  

(OR)

BEGIN dbms_stats.gather_schema_stats(ownname=>'MYSCHEMA', cascade => TRUE, method_opt => 'FOR ALL COLUMNS SIZE AUTO',options=>'gather auto',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE, degree=>3); END;

I see the below errors,

*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query
server P00F
ORA-00600: internal error code, arguments: [kaf lob buffer overwrite], [1630],
[466], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 38298
ORA-06512: at "SYS.DBMS_STATS", line 38257
ORA-06512: at "SYS.DBMS_STATS", line 38074
ORA-06512: at "SYS.DBMS_STATS", line 37333
ORA-06512: at "SYS.DBMS_STATS", line 36451
ORA-06512: at "SYS.DBMS_STATS", line 35428
ORA-06512: at "SYS.DBMS_STATS", line 33883
ORA-06512: at "SYS.DBMS_STATS", line 32254
ORA-06512: at "SYS.DBMS_STATS", line 32234
ORA-06512: at "SYS.DBMS_STATS", line 33472
ORA-06512: at "SYS.DBMS_STATS", line 35304
ORA-06512: at "SYS.DBMS_STATS", line 36230
ORA-06512: at "SYS.DBMS_STATS", line 37245
ORA-06512: at "SYS.DBMS_STATS", line 37967
ORA-06512: at "SYS.DBMS_STATS", line 38207
ORA-06512: at "SYS.DBMS_STATS", line 38285
ORA-06512: at line 1
Tags : oracle-12c


Related Questions


Updated February 05, 2018 08:06 AM

Updated July 03, 2016 08:02 AM

Updated February 24, 2017 12:06 PM

Updated August 28, 2017 14:06 PM

Updated August 02, 2018 06:06 AM