During an analysis job run you receive the following Oracle error in the table QUEST_SPC_ANALYSIS_ERROR:
"ORA-01476: divisor is equal to zero"
This is an intermittent Oracle Bug in Oracle versions 10.2.0.1 to 10.2.0.4 see also Oracle Metalink Doc: 464440.1
Workaround 1:
1. SQL> select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;
2. for each of the "locked" tables run:
SQL> exec dbms_stats.unlock_table_stats('OWNER','TABLE_NAME');
3. SQL> select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;
4. Run the analysis again.
Workaround 2:
Follow the Solution steps in Oracle metalink Doc ID: 464440.1
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center