QUESTION 28
You have a range-partitioned table in your database. Each partition in the table contains the sales data
for a quarter.
The partition related to the current quarter is modified frequently and other partitions undergo fewer data
manipulations. The preferences for the table are set to their default values. You collect statistics for the
table using the following command in regular intervals:
SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS(‘SH’,’SALES’,GRANULARITY=>’GLOBAL’);
You need statistics to be collected more quickly. What can you do to achieve this?
A. Set DYNAMIC_SAMPLING to level 4.
B. Set the STATISTICS_LEVEL parameter to BASIC.
C. Set the INCREMENTAL value to TRUE for the partition table.
D. Increase the value of STALE_PERCENT for the partition table.
Correct Answer: C
数据库中有一个分区表。表中的每个分区包含销售数据
一个季度。
分区与当前季度的修改频繁，其他分区进行较少的数据
操作。表的首选项设置为默认值。你收
集统计
使用下列命令在规则的时间间隔中使用下列命令：
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(‘SH’,GRANULARITY=>’GLOBAL’);
你需要统计数据更快速地收集。你能做什么来实现这个
C.为分区表设置增量值。
