Oracle delete statistics

-- delete statistics for database

begin
DBMS_STATS.DELETE_DATABASE_STATS;
end;


--delete statistics schema

exec DBMS_STATS.DELETE_SCHEMA_STATS('PROD1');

exec dbms_stats.delete_schema_stats('SYS');


delete statistics Table


begin
DBMS_STATS.DELETE_TABLE_STATS (
ownname => 'PROD1',
tabname => 'SITE',
partname => NULL,
stattab => NULL,
statid => NULL,
cascade_parts => TRUE,
cascade_columns => TRUE,
cascade_indexes => true,
statown => NULL,
no_invalidate => FALSE);
end;