2018-12-03

ORA-06512: at "SYS.DBMS_STATS", line 34634

BEGIN DBMS_STATS.GATHER_TABLE_STATS('SYS','X$KTFBUE'); END;

*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "SYS.DBMS_STATS", line 34634
ORA-06512: at line 1

The solution is to the install patch for Bug 20783502.

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'




FOR 12C: exec DBMS_STATS.GATHER_TABLE_STATS('SYS','X$KTFBUE',method_opt=> 'for all columns size auto');

Niciun comentariu:

Trimiteți un comentariu