ORA-01476 Error Executing DBMS_STATS.GATHER_SCHEMA_STATS

Today has reached an alarm with the error below;

 

ORA-01476: divisor is equal to zero

 
This error has been produced executing  GATHER_TABLE_STATS procedure. This database is older, a 10.2.0.2 version. After researching I see there is a Doc ID 464440.1 note in MOS,  which refers to two possible bugs, bugs 5645718 and 6319761 both suggest the same solution to fix the problem.

 

alter system set events ‘38041 trace name context forever, level 16’ scope=both;

alter system set events ‘38041 trace name context forever, level 24’ scope=both;

 

Conclusions;

  • Execute the alter system solves the problem
  • This version is obsolete would have to go to latest versions, at least 11.2

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s