Oracle 表统计信息收集

–收集统表计信息

–普通表

begin
  dbms_stats.gather_table_stats(ownname          => 'LUAN_ZXK',
                                tabname          => 'PHASH_AKM01',
                                estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
                                method_opt       => 'for all indexed columns',
                                cascade          => true,
                                degree           => 4);
end;

查看统计信息收集情况

select table_name, tablespace_name, NUM_ROWS, last_analyzed
from dba_tables where table_name = 'LUAN_SB';

–分区表

begin
  dbms_stats.gather_table_stats(ownname          => 'O_PRO_SB',
                                tabname          => 'PARTI_SB',
                                estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
                                method_opt       => 'for all indexed columns',
                                cascade          => true,
                                granularity      => 'all',
                                degree           => 8);
end;

granularity =>'all' --收集所有分区信息

select table_name,PARTITION_name,high_value,
PARTITION_POSITION tablesoace_name,NUM_ROWS,last_analyzed
from dba_tab_partitions where table_name='PARTI_SB'