"ORA-01476: divisor is equal to zero" Encountered when Executing DBMS_STATS.GATHER_TABLE_STATS with AUTO_SAMPLE_SIZE
Last updated on OCTOBER 26, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Information in this document applies to any platform.
- While gathering statistics using DBMS_STATS.GATHER_TABLE_STATS with AUTO_SAMPLE_SIZE the following error is received:
- A REPEAT option is used in the METHOD_OPT clause, such as using method_opt=>'for all columns size repeat' instead of the default 'for all columns size auto'. This may be set by a global preference, as well as in the statement itself.
Error encountered following an upgrade to Oracle 18.104.22.168.0 from an earlier release.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms