Oracle
1Z0-417 · Question #36
Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?
Sign in or unlock 1Z0-417 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Automatic Performance Tuning Features
Question
Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?
Options
- Alock out user sessions and gather system statistics overnight
- Bgather system statistics after a performance issue has been reported
- Cgather system statistics for several hours when there is no workload
- Dgather system statistics for several hours during normal workload periods
- Eshut down any running applications prior to collection
Unlock 1Z0-417 to see the answer
You've previewed enough free 1Z0-417 questions. Unlock 1Z0-417 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#optimizer statistics#system statistics#workload analysis#DBMS_STATS