1Z0-062 · Question #142
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
The correct answer is D. The job is terminated and statistics for the remaining objects are collected the next time the. The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The…
Question
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
Options
- AThe job is terminated and the gathered statistics are not saved.
- BThe job is terminated but the gathered statistics are not published.
- CThe job continues to run until all statistics are gathered.
- DThe job is terminated and statistics for the remaining objects are collected the next time the
How the community answered
(40 responses)- A8% (3)
- B3% (1)
- C3% (1)
- D88% (35)
Explanation
The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.
Topics
Community Discussion
No community discussion yet for this question.