Stats

BEGIN dbms_stats.gather_schema_stats('SYS', cascade=>TRUE) ; END;

 

BEGIN dbms_stats.gather_fixed_objects_stats(); END;

 

BEGIN
FOR rec IN (
SELECT owner, table_name, DBMS_LOB.substr(extension, 3000) extension
FROM dba_stat_extensions
WHERE droppable='YES'
)
LOOP
dbms_output.put_line('Dropping extended stats for ' ||rec.owner||'-'|| rec.table_name ||' '|| rec.extension);
dbms_stats.drop_extended_stats( rec.owner, rec.table_name, rec.extension );
END LOOP;
END;

 

declare
    exadata_used number :=0;
begin
    select count(*) into exadata_used from DBA_FEATURE_USAGE_STATISTICS where name ='Exadata' and CURRENTLY_USED ='TRUE';
IF exadata_used >0
THEN
    dbms_stats.gather_system_stats('EXADATA');
ELSE
    dbms_stats.gather_system_stats();
END IF;
END;

 

BEGIN dbms_workload_repository.create_snapshot(); END;