ORA-20000: Statistics collection failed for 533 objects in the schema

Cause:

ORA-20000: Statistics collection failed for 533 objects in the schema
ORA-06512: at "SYS.DBMS_STATS", line 42210
ORA-06512: at "SYS.DBMS_STATS", line 42165
ORA-06512: at "SYS.DBMS_STATS", line 42133
ORA-06512: at "SYS.DBMS_STATS", line 42196
ORA-06512: at line 1

Action:

Check for invalid or unusable indexes and rebuild them

SQL> select count(*) from dba_indexes where status <> 'VALID';

 COUNT(*)
----------
      250

select 'alter index '||owner||'.'||index_name||' rebuild online;' from all_indexes where status <> 'VALID';.

Select 'alter index '||index_owner||'.'||index_name||' rebuild partition '||partition_name||' ONLINE;' from all_ind_partitions where status <> 'VALID'

Select 'alter index '||index_owner||'.'||index_name||' rebuild subpartition '||subpartition_name||' ONLINE;' from all_ind_subpartitions where status <> 'VALID'

Leave a Reply