快速收集统计信息,利用并行等,比如CPU 96,比较空闲idle 90%以上,可以考虑使用32个CPU
alter session set workarea_size_policy=manual;
alter session set sort_area_size=1073741820;
alter session set sort_area_retained_size=1073741820;
alter session set db_file_multiblock_read_count=128;
exec dbms_stats.gather_table_stats(ownname =>'XXX',tabname =>'XXX',degree => '32',cascade=>true);
select num_rows,sample_size,last_analyzed,degree from user_tables where table_name='XXX';
select index_name,num_rows,sample_size,last_analyzed,degree from user_indexes where table_name='XXX';