天萃荷净

Oracle数据库alert日志报错ORA-01476，分析原因与DBMS_STATS.GATHER_SCHEMA_STATS有关

alert日志

Fri Jan 27 22:00:09 2012

GATHER_STATS_JOB encountered errors. Check the trace file.

Fri Jan 27 22:00:09 2012

Errors in file /oracle10/admin/ocs/bdump/ocs1_j001_29138.trc:

ORA-01476: divisor is equal to zero

trace内容

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

ORACLE_HOME = /oracle10/app/product/db/10.2.0

System name: HP-UX

Node name: ocsdb1

Release: B.11.23

Version: U

Machine: ia64

Instance name: ocs1

Redo thread mounted by this instance: 1

Oracle process number: 60

Unix process pid: 29138, image: oracle@ocsdb1 (J001)

*** ACTION NAME:(GATHER_STATS_JOB) 2012-01-27 22:00:09.308

*** MODULE NAME:(DBMS_SCHEDULER) 2012-01-27 22:00:09.308

*** SERVICE NAME:(SYS$USERS) 2012-01-27 22:00:09.308

*** SESSION ID:(988.31342) 2012-01-27 22:00:09.307

ORA-01476: divisor is equal to zero

*** 2012-01-27 22:00:09.417

GATHER_STATS_JOB: GATHER_TABLE_STATS('"OCS_SM"','"HLP_SMS_SEND"','""', ...)

ORA-01476: divisor is equal to zero

错误原因

oracle unpublished Bug 5645718

解决方法

1.Setting event 38041 at level 16

sql> connect / as sysdba

sql> alter system set events '38041 trace name context forever, level 16';

2.Patch 6319761

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之案例:Oracle数据库报错 alert日志ORA-01476: divisor is equal to zero