Oracle 19c全库统计信息收集

1.设置并行收集https://www.cndba.cn/hbhe0316/article/4927https://www.cndba.cn/hbhe0316/article/4927https://www.cndba.cn/hbhe0316/article/4927https://www.cndba.cn/hbhe0316/article/4927https://www.cndba.cn/hbhe0316/article/4927https://www.cndba.cn/hbhe0316/article/4927

https://www.cndba.cn/hbhe0316/article/4927

https://www.cndba.cn/hbhe0316/article/4927

SQL> set timing on
SQL> exec dbms_stats.set_global_prefs('CONCURRENT','TRUE');

PL/SQL procedure successfully completed.

2.开始收集全库统计信息

https://www.cndba.cn/hbhe0316/article/4927

begin
dbms_stats.gather_database_stats(ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'for all indexed columns', cascade=>true, degree=>120);
end;
/

PL/SQL procedure successfully completed.

Elapsed: 00:03:52.55

3.关闭并行收集

https://www.cndba.cn/hbhe0316/article/4927

SQL> exec dbms_stats.set_global_prefs('CONCURRENT','FALSE');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.03
SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle