Delete statistics of the complete database -- Delete statistics of a single schema -- Delete statistics of single tabale EXEC DBMS_STATS.delete_table_stats('DBACLASS', 'DEPT'); -- Delete statistics of a column EXEC DBMS_STATS.delete_column_stats('DBACLASS', 'DEPT', 'CLASS'); --Delete statistics of an index --Delete dictionary a in db

1
2
3
4

EXEC DBMS_STATS.delete_database_stats;
EXEC DBMS_STATS.delete_schema_stats('DBACLASS');
EXEC DBMS_STATS.delete_index_stats('DBACLASS', 'CLASS_IDX');
EXEC DBMS_STATS.delete_dictionary_stats;