Delete statistics - oracle database script

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