vincent 发表于 2013-12-10 10:52:04

请问如何修改自动任务默认分析的百分比

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE        11.2.0.4.0        Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

我想问下 oracle自动任务默认分析修改10%的表，在哪里可以修改这个百分比

Liu Maclean(刘相兵 发表于 2013-12-10 10:54:46

STALE_PERCENT
STALE_PERCENT - This value determines the percentage of rows in a table that have to change before the statistics on that table are deemed stale and should be regathered. The default value is 10%.

11g新加入到dbms_stats的一个 参数
页: [1]
查看完整版本: 请问如何修改自动任务默认分析的百分比