Friday, August 5, 2011

ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists Statistics Gathering

You might encounter the following error in your alert log file:

ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists

*** 2011-08-04 22:54:30.487
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"owner"','"tablename"','""', ...)
DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists

On investigation, you tend to see that both the table and the dbms_stats objects exist and the statistics job failed just for this table. This might be a bug or more likely a transient hiccup with the statistics gathering job. You can verify that by just gathering the statistics manually for that table.

exec dbms_stats.gather_table_stats(ownname=>'',tabname=>'', ESTIMATE_PERCENT=>.01, METHOD_OPT=> 'FOR ALL INDEXED COLUMNS',CASCADE=>TRUE,DEGREE=>6);

If it fails again, then you need to look into the accompanying trace file and log an SR for a likely bug.

No comments: