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.
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=>'
If it fails again, then you need to look into the accompanying trace file and log an SR for a likely bug.
No comments:
Post a Comment