这是在数据库升级到10.2.0.4以后做分析时碰到的问题。

[@more@]

Subject:
Getting ORA-01476 during execution of DBMS_STATS.GATHER_SCHEMA_STATS

Doc ID:
464440.1
Type:
PROBLEM

Modified Date :
30-MAR-2009
Status:
MODERATED

In this Document
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4
This problem can occur on any platform.
Symptoms
-- Problem Statement:
Intermittent ORA-01476: divisor is equal to zero when running gather schema stats.

*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "SYS.DBMS_STATS", line 13313
ORA-06512: at "SYS.DBMS_STATS", line 13659
ORA-06512: at "SYS.DBMS_STATS", line 13737
ORA-06512: at "SYS.DBMS_STATS", line 13696
ORA-06512: at line 1
Analyse using dbms_stats.gather_table_stats gave error for a table. But, it generally runs fine. The error is intermittent but still occurs occassionally.

Cause
Bug 5645718 10.2.0.2 RDBMS 10.2.0.2 QRY OPTIMIZER PRODID-5 PORTID-197 ORA-1476
Abstract: ORA-1476 DBMS_STATS.GATHER_TABLE_STATS
--> Fixed-Releases: 10.2.0.4, 11.1.0.6

Bug 6319761 10.2.0.3 RDBMS 10.2.0.3 QRY OPTIMIZER PRODID-5 PORTID-23 ORA-1476
Abstract: DBMS_STATS.GATHER_SCHEMA_STATS IS FAILING WITH ORA-1476
--> Fixed-Release: 11.1.0.7

Both bugs are related to scaling of "number of distinct values" with popular values while gathering stats.
Solution
Kindly disable popular values adjustment for NDV scaling.
-- To implement the solution, please execute the following steps::
sql> connect / as sysdba
sql> alter system set events '38041 trace name context forever, level 16';