1Z0-117 · Question #60
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…
The correct answer is B. Set the STALE_PERCENT static preference to a higher value for these tables. 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…
Question
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?
Options
- ASet the INCREMENTAL statistic preference FALSE for these tables.
- BSet the STALE_PERCENT static preference to a higher value for these tables.
- CSet the GRANULARITY statistic preference to AUTO for these tables.
- DSet the PUBLISH statistic preference to TRUE for these tables.
How the community answered
(41 responses)- A2% (1)
- B85% (35)
- C5% (2)
- D7% (3)
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
Topics
Community Discussion
No community discussion yet for this question.