oracle 手动收集统计信息
1、手动收集Oracle schema下表列信息
begin
dbms_stats.gather_schema_stats(ownname => '用户名',
method_opt => 'for all columns size repeat',
degree => 8,
options => 'GATHER AUTO',
estimate_percent => dbms_stats.auto_sample_size);
end;
/
2、收集整个数据库
begin
dbms_stats.gather_database_stats(degree => 4);
end;
/