Gather Partition Tables's Statistics
No Table Name Size(M) Rows Growth(Rows)/Day Gather Statistics Scripts
1 WIP_D_SN_INPUT 1.76G 20,664,834 "
exec dbms_stats.gather_schema_stats(ownname => 'DFMS',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all columns size auto',
cascade=>TRUE,
degree => 8 ) ;
DFMS普通表及分区表优化大概需要20分钟左右。 "
2 WIP_D_SN_DETAIL 4.98G 20,638,212
3 WIP_D_WO_DETAIL 3.76G 19,516,907
4 WIP_D_CSN_DETAIL 2.83G 19,210,008
5 WIP_L_ASSY_COMPONENT 3.37G 18,786,437
6 WIP_D_CSN_MASTER 2.64G 11,672,782
7 WIP_D_STATION_UPH 1.37G 7,361,454
8 EDIBTO850_DETAIL 1.61G 5,555,684
9 EDIBTO850_PO1PID 1.22G 5,554,961
10 WIP_D_CWO_PARTLIST 6.15G 102,808,290 切換前變更為分區表
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-706257/,如需转载,请注明出处,否则将追究法律责任。