ORA-01476: divisor is equal to zero doing a dbms_stats
Hi experts.
Database Enterprise Edition, version 9.2.0.8 in Aix 5.3.
Per Bug Bug 5887722 : ORA-01476 DBMS_STATS ESTIMATE_PERCENT DBMS_STATS.AUTO_SAMPLE, I did an "alter system set events '38041 trace name context forever,level 16';" , but the error continues:
SQL> SQL> 10:49:41 SQL> 10:49:41 SQL> BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'ASAP',cascade=>TRUE,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>4); END;
*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "SYS.DBMS_STATS", line 10502
ORA-06512: at "SYS.DBMS_STATS", line 10996
ORA-06512: at "SYS.DBMS_STATS", line 11183
ORA-06512: at "SYS.DBMS_STATS", line 11237
ORA-06512: at "SYS.DBMS_STATS", line 11214
0