Today has reached an alarm with the error below;
ORA-01476: divisor is equal to zero
This error has been produced executing GATHER_TABLE_STATS procedure. This database is older, a 10.2.0.2 version. After researching I see there is a Doc ID 464440.1 note in MOS, which refers to two possible bugs, bugs 5645718 and 6319761 both suggest the same solution to fix the problem.
alter system set events ‘38041 trace name context forever, level 16’ scope=both;
alter system set events ‘38041 trace name context forever, level 24’ scope=both;
- Execute the alter system solves the problem
- This version is obsolete would have to go to latest versions, at least 11.2
HTH – Antonio NAVARRO