ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no

RDBMS 11.2.0.1 

PLATFORM :AIX 6.1

在alertlog中發現ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no exist 告警。

告警具體內容為

gather_stats_job encountered errors.check the trace file.
errors in file XXX
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist 

其中trc檔案的大概內容如下：

MODULE_NAME:DBMS_SCHEDULER
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist
gather_stats_job:gather_stats_job("XXX","XXX","",...)
ORA-20000:unable to analyze table "XXX"."XXX",insufficient privileges or does not exist

排查過程：

在MOS上檢視錯誤資訊，發現以下文章的內容和錯誤較類似，也提供了相關的思路。

Gather Schema Statistics Errors with APPS.EUL5_B<number> ORA-20000 Unable to analyze TABLE (文件 ID 1680854.1)

DBMS_STATS: GATHER_STATS_JOB encountered errors. ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges (文件 ID 1463793.1)

該MOS上關於該錯誤的一些解釋

This issue matches Bug 9939773 which was closed as not a bug as explained by the following description:
"
The compression advisor creates intermediate tables (creates/drops tables DBMS_TABCOMP_TEMP_UNCMP). In case a GATHER_STATS_JOB is run at the same time , the table(s) will be in the list of tables to be analyzed. In case the table is automatically dropped by the compression advisory job before the GATHER_STATS_JOB has reached to that table in the list, the ORA-2000 will be hit. When DBMS_STATS finds it is no longer available, it writes to the alert log.This is no different from the case where a user table is dropped during a statistics gather. 
"

 These tables are summary tables which only exist when the Discoverer scheduled batch job to create the summaries is still running and will then be dropped.

另外，在查詢DBMS_TABCOMP_TEMP_UNCMP這個表的時候，發現庫中是沒有這個表的。無論是查詢dba_tables 還是desc表。都沒有的。從MOS上的一些解釋可以看到，該表為臨時的表，會被刪掉。而自動優化統計資訊任務在執行的時候，可能資料字典中還認為存在這個表。但實際這個表已經不存在了。所以會出現這個錯誤。從MOS上的解釋看。不影響後續的優化統計資訊的Job的執行。

END。