重庆思庄技术分享- 统计信息收集期间的ORA-00604和ORA-06512

现象自动统计信息job失败报错:ORA-00604: error occurred at recursive SQL level10046 trace显示如下错误:ERROR #236896985136:err12899 tim38284535671327 ORA-12899: value too large for columnORA-12012: error on auto execute of job 22407ORA-06512: at SYS.DBMS_STATS, line 36873ORA-12899: value too large for column SYS.WRI$_OPTSTAT_OPR.JOB_NAME(actual: 51, maximum: 32)ORA-06512: at SYS.DBMS_STATS, line 2061ORA-06512: at SYS.DBMS_STATS, line 36713ORA-06512: at line 1 .原因在12.2.0.1版本报告了此问题这是由以下bug导致Bug 28090604 : DBMS_STATS FAIL ORA-12899: VALUE TOO LARGE FOR COLUMN SYS.WRI$_OPTSTAT_OPR .JOB_解决方案1. Bug在20.1版本修复2. 应用 Patch 28090604