在一台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
请大家看下是什么原因导致的？怎么解决？
核心数据字典视图不能这么玩吧
试试这个？
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
评论
有用 1
