[20130924]12c dbms_stats包的一些預設參數.txt

[20130924]12c dbms_stats包的一些預設參數.txt

11G下：

12C增加了如下參數options,GLOBAL_TEMP_TABLE_STATS,INCREMENTAL_LEVEL,INCREMENTAL_STALENESS：

--   options - further specification of which objects to gather statistics for

--      'GATHER' - gather statistics on all objects in the schema

--      'GATHER AUTO' - gather all necessary statistics automatically. Oracle

--        implicitly determines which objects need new statistics.