重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1885|回复: 0
打印 上一主题 下一主题

[Oracle] GATHER_STATS_JOB encountered errors. ORA-20000

[复制链接]
跳转到指定楼层
楼主
发表于 2018-3-3 16:56:14 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
[size=130%]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
[size=130%]

[size=130%]In this Document
Symptoms
Changes
Cause
Solution
References



Applies to:   Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms
  • Alert log shows the error messages below: ...
    Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
    2012-05-24 22:00:13.107000 +02:00
    DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.
    Errors in file /data01/oracle/diag/rdbms/octoprd/OCTOPRD2/trace/OCTOPRD2_j002_2772.trc:
    ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges
    ...
  • Complete stack of errors in the trace may also contain: ...
    ORA-20011: Approximate NDV failed:
    ORA-08103: object no longer exists
    ...


ChangesNone
CauseThis 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.
"
Solution You can ignore this error due to following:
  • The error is non-critical.
  • Other objects won't be affected by this error and gather stats job continues safely on other user objects. The error will not result in the termination of the gather stats job for the rest of the tables.
  • The message in the alert log is only informative.
ReferencesNOTE:1247864.1 - DataPump Export Raises ORA-31693 ORA-2354 ORA-942 On DBMS_TABCOMP_TEMP_CMP And DBMS_TABCOMP_TEMP_UNCMP





[size=130%]

分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-1 07:52 , Processed in 0.081290 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表