Jay Z DBA
msgbartop
At the Center of Technologies
msgbarbottom

16 Oct 08 ORA-01476: divisor is equal to zero

Due to a bug in Oracle 10g, some 10g databases generate hourly errors in mxxx trace files like this:

ORA-01476: divisor is equal to zero

This is claimed to have been fixed in 11g. An workaround in 10g is to make sure DB_CACHE_ADVICE is NOT set as READY. Either comment it out or set it as ON (default).

Tags: ,



Leave a Comment