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

你在你的數(shù)據(jù)庫中有1個范圍分區(qū)的表。表中的每一個分
區(qū)包括1個季度的銷售數(shù)據(jù)。有關(guān)當(dāng)前季度的分區(qū)被頻繁修改，其他分區(qū)進(jìn)行較少地數(shù)據(jù)操作。表中的首選項
設(shè)置為默許值。您可以定期使用下面的命令搜集表的統(tǒng)計信息：
你需要更迅速地搜集統(tǒng)計。你可以做些甚么來實現(xiàn)這1目標(biāo)？

C.為分區(qū)表設(shè)置增長值為真。