统计信息收集期间的ORA-00604和ORA-06512

刘泽宇

现象：
自动统计信息job失败报错:
ORA-00604: error occurred at recursive SQL level

10046 trace显示如下错误:  
ERROR #236896985136:err=12899 tim=38284535671327 >>>>>> ORA-12899: value too large for column

ORA-12012: error on auto execute of job 22407
ORA-06512: at "SYS.DBMS_STATS", line 36873
ORA-12899: value too large for column "SYS"."WRI$_OPTSTAT_OPR"."JOB_NAME"
(actual: 51, maximum: 32)
ORA-06512: at "SYS.DBMS_STATS", line 2061
ORA-06512: at "SYS.DBMS_STATS", line 36713
ORA-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>