Which task would you perform to achieve this?

You are administering a database supporting a DDS workload in which some tables are updated
frequently but not queried often. You have SQL plan baseline for these tables and you do not want
the automatic maintenance task to gather statistics for these tables regularly.
Which task would you perform to achieve this?

You are administering a database supporting a DDS workload in which some tables are updated
frequently but not queried often. You have SQL plan baseline for these tables and you do not want
the automatic maintenance task to gather statistics for these tables regularly.
Which task would you perform to achieve this?

A.
Set the INCREMENTAL statistic preference FALSE for these tables.

B.
Set the STALE_PERCENT static preference to a higher value for these tables.

C.
Set the GRANULARITY statistic preference to AUTO for these tables.

D.
Set the PUBLISH statistic preference to TRUE for these tables.

Explanation:
With the DBMS_STATS package you can view and modify optimizer statistics
gathered for database objects.
STALE_PERCENT – This value determines the percentage of rows in a table that have to change
before the statistics on that table are deemed stale and should be regathered. The default value is
10%.
Reference: Oracle Database PL/SQL Packages and Types Reference



Leave a Reply 1

Your email address will not be published. Required fields are marked *