begin
for vi in (select * from dba_tables where owner in (select user from dual))
loop
DBMS_STATS.gather_table_stats(vi.owner,vi.table_name,estimate_percent => 20,degree=> 7);
end loop;
end;
oracle清理碎片
最新推荐文章于 2021-10-08 14:48:30 发布
begin
for vi in (select * from dba_tables where owner in (select user from dual))
loop
DBMS_STATS.gather_table_stats(vi.owner,vi.table_name,estimate_percent => 20,degree=> 7);
end loop;
end;