2018-12-28

program wallpaper

https://www.setaswall.com/programming-wallpapers/programming-wallpapers-23-1600-x-873/

zh

Medicul Vasi Rădulescu: „Zahărul nu lasă loc de discuții: te ucide într-un mod perfid, ținându-te captiv, măcinându-te puțin câte puțin, alterându-ți nervii, vasele de sânge, organele.”

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');

ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high