oracle中收集统计信息报错

我来答

2021-10-13

oracle中收集统计信息报错

在一台oracle 11.2.0.3 的单机数据库中执行统计信息收集时报错：

sys@ORCL> exec dbms_stats.gather_fixed_objects_stats('X$KSUSE');
BEGIN dbms_stats.gather_fixed_objects_stats('X$KSUSE'); END;

*
ERROR at line 1:
ORA-20000: Statistics collection failed for 820 fixed objects
ORA-06512: at "SYS.DBMS_STATS", line 25419
ORA-06512: at line 1

请大家看下是什么原因导致的？怎么解决？

我来答

添加附件

问题补充

4条回答

默认

最新

JiekeXu

核心数据字典视图不能这么玩吧

试试这个？

SQL> exec dbms_stats.gather_table_stats('SYS','X$KSUSE')

PL/SQL procedure successfully completed.

SQL> select OWNER, TABLE_NAME,LAST_ANALYZED,num_rows from dba_tab_statistics where table_name like 'X$KSUSE';

OWNER TABLE_NAME LAST_ANALYZED NUM_ROWS
------------------------------ ------------------------------ ------------------- ----------
SYS X$KSUSE 2021-10-13 20:02:01 248