Oracle
1Z0-054 · Question #33
You have the automatic optimizer statistics gathering enabled for a 24x7 database as part of the automatic maintenance task. Because the automatic optimizer statistics collection runs during…
The correct answer is D. Gather statistics on the table when the tables have a representative number of rows, and then. 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. Because the automatic optimizer statistics collection runs during maintenance window(in the night), the statistics on tables that are significantly modified throughout the day becomes stale. This leads to poor query performance on these tables and you want to minimize the overhead in statistics collection. Identify a solution to this problem.
Options
- AChange the STALE_PERCENT preference to zero for the tables.
- BSet the OPTIMIZER_USE_PENDING parameter statistics to TRUE.
- CSet the OPTIMIZER_DYNAMIC_SAMPLING parameter to zero during day time.
- DGather statistics on the table when the tables have a representative number of rows, and then
How the community answered
(37 responses)- A5% (2)
- B5% (2)
- C16% (6)
- D73% (27)
Community Discussion
No community discussion yet for this question.