*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "SYS.DBMS_STATS", line 34634
ORA-06512: at line 1
As a workaround, you can avoid the issue by disabling Hybrid Histograms using:
exec dbms_stats.set_global_prefs('ENABLE_HYBRID_HISTOGRAMS',0);
or
remove any REPEAT options in METHOD_OPT clause of DBMS_STATS.GATHER_TABLE_STATS. In other words change:
method_opt=>'for all columns size repeat'
back to the default:
method_opt=> 'for all columns size auto'
Niciun comentariu:
Trimiteți un comentariu