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/，如需转载，请注明出处，否则将追究法律责任。