1 Reply Latest reply: Nov 7, 2012 5:26 AM by Balazs Papp RSS

    ORA-01476: divisor is equal to zero

      Hi Gurus,

      I have encountered below error message for one of my RAC instance -
      GATHER_STATS_JOB encountered errors.  Check the trace file.
      Tue Nov  6 22:00:31 2012
      Errors in file /export/home/oracle/admin/***/bdump/***_j001_20993.trc:
      ORA-01476: divisor is equal to zero
      Below is the stats job that it is showing -
      GATHER_STATS_JOB   6503                1 +000 01:24:03.24 +000 00:46:28.71
      Please let me know the next action item for the above error message
        • 1. Re: ORA-01476: divisor is equal to zero
          Balazs Papp
          you marked the 11gr2 tag, but i think you are on a previous version, based on the bdump location and the difference in statistics gathering mechanism in 11.2

          there are some bugs related to this for 10.2 and earlier versions:

          Bug 5645718 - ORA-1476 gathering statistics with DBMS_STATS - superseded [ID 5645718.8]
          Bug 6319761 - ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS [ID 6319761.8]
          DBMS_STATS fails with ORA-01476 with patch 5645718 applied [ID 456857.1]
          Bug 6130124 : ORA-01476 DBMS_STAT.GATHER_DATABASE_STAT