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.
Explanation:
Oracle will update the global table statistics by scanning only the partitions that have been
changed instead of the entire table if the following conditions hold:
INCREMENTAL value for the partitioned table is set to TRUE
PUBLISH value for the partitioned table is set to TRUE;
User specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for
GRANULARITY when gathering statistics on the table
If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full
table scan is used to maintain the global statistics which is a much more resource intensive
and time-consuming operation for large tables.
Here are some links to internet sites that we link to because we believe they’re really worth visiting.
below youll come across the link to some internet sites that we feel you need to visit
below youll locate the link to some web pages that we feel you should visit
please stop by the web sites we stick to, which includes this one particular, as it represents our picks in the web
always a big fan of linking to bloggers that I appreciate but really don’t get a whole lot of link appreciate from
the time to read or take a look at the content material or internet sites we have linked to below the
the time to study or stop by the subject material or web sites we have linked to beneath the
check below, are some absolutely unrelated websites to ours, nonetheless, they’re most trustworthy sources that we use