QUESTION NO: 529？
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.
Answer: C
你在你的数据库中有1个范围分区的表。表中的每一个分
区包括1个季度的销售数据。有关当前季度的分区被频繁修改，其他分区进行较少地数据操作。表中的首选项
设置为默许值。您可以定期使用下面的命令搜集表的统计信息：
你需要更迅速地搜集统计。你可以做些甚么来实现这1目标？
C.为分区表设置增长值为真。