"ORA-01476: divisor is equal to zero" Encountered when Executing DBMS_STATS.GATHER_TABLE_STATS with AUTO_SAMPLE_SIZE
(Doc ID 2017251.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 22.214.171.124.0 from an earlier release.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document