ORA-00604 and ORA-06512 During Stats Gathering
(Doc ID 2493153.1)
Last updated on NOVEMBER 26, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
- Auto stats job failing with:
ORA-00604: error occurred at recursive SQL level
- 10046 trace shows following error:
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 .
The issue was reported on 184.108.40.206
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