[20220217]完善tpt gts.sql指令碼.txt

[20220217]完善tpt gts.sql指令碼.txt

--//有時候不小心使用gts分析生產系統的表,選擇FOR TABLE FOR ALL COLUMNS SIZE 1,導致直方圖消失.修改採用repeat,這樣更加安全
--//一些.
--//method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE 1'為method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE REPEAT'.

-- Copyright 2018 Tanel Poder. All rights reserved. More info at
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.

prompt Gather Table Statistics for table &1....
exec dbms_stats.gather_table_stats(null, upper('&1'), null, method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE REPEAT', cascade=>true, no_invalidate=>false);