"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 15, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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.
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