Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?

Question

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

• A
  9% (5)
• B
  2% (1)
• C
  5% (3)
• D
  82% (45)
• E
  2% (1)

Explanation

https://docs.oracle.com/database/121/TGSQL/tgsql_stats.htm#TGSQL398

No community discussion yet for this question.