查看搜集统计信息的estimate_percent

estimate_percent:采样行的百分比,取值范围[0.000001,100],null为全部分析,不采样. 

常量:DBMS_STATS.AUTO_SAMPLE_SIZE是默认值,由oracle决定最佳取采样值.

自动估计要采样的一个segment的最佳百分比：

DBA_TABLES:
SAMPLE_SIZE	NUMBER	Sample size used in analyzing this table


SQL> select owner, table_name, tablespace_name, sample_size
  2    from all_tables
  3   where table_name = 'TEST'
  4     and owner = 'TEST';

OWNER      TABLE_NAME           TABLESPACE_NAME                SAMPLE_SIZE
---------- -------------------- ------------------------------ -----------
TEST       TEST                 TEST                                 72605


 BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(ownname          => 'TEST',
                                tabname          => 'TEST',
                                estimate_percent => 100,
                                method_opt       => 'for all columns size repeat',