Gather DBMS_STATS Default parameter
What are the default parameter values ?
select dbms_stats.get_param('cascade') from dual; select dbms_stats.get_param('degree') from dual; select dbms_stats.get_param('estimate_percent') from dual; select dbms_stats.get_param('method_opt') from dual; select dbms_stats.get_param('no_invalidate') from dual; select dbms_stats.get_param('granularity') from dual; DEFAULT PARAMETER DBMS_STATS.AUTO_CASCADE NULL DBMS_STATS.AUTO_SAMPLE_SIZE FOR ALL COLUMNS SIZE AUTO DBMS_STATS.AUTO_INVALIDATE AUTO
posted on 2013-03-19 00:32 Oracle和MySQL 阅读(106) 评论(0) 编辑 收藏 举报