Oracle
1Z0-054 · Question #32
You have the automatic optimizer statistics gathering enabled for a 24x7 database as part of the automatic maintenance task. You observed that a few tables are being updated regularly, but not being…
The correct answer is B. Increase the value of the STALE_PERCENT preference for these tables. See the full explanation below for the reasoning.
Question
You have the automatic optimizer statistics gathering enabled for a 24x7 database as part of the automatic maintenance task. You observed that a few tables are being updated regularly, but not being queried often. However statistics are being gathered for these tables automatically and regularly, thereby affecting the database performance. What would you do to increase the interval of statistics collection for these tables so that the statistics collection jobs spend less time during the automatic maintenance task?
Options
- ASet the OPTIMIZER_USE_PENDING parameter statistics to TRUE.
- BIncrease the value of the STALE_PERCENT preference for these tables.
- CMark those associated indexes that are less frequently used as invisible.
- DIncrease the value of the ESTIMATE_PERCENT preference for these tables
How the community answered
(16 responses)- B88% (14)
- C6% (1)
- D6% (1)
Community Discussion
No community discussion yet for this question.