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