Oracle Schema gather stats

Begin
dbms_stats.gather_schema_stats(
ownname => ‘HR’, — schema name
options => ‘GATHER AUTO’,
estimate_percent => dbms_stats.auto_sample_size,
method_opt => ‘for all columns size repeat’,
degree => 2
);
END;
/

Leave a Reply

Your email address will not be published. Required fields are marked *