Which option is recommended when gathering Optimizer system statistics on a regular basis to ensure optimal performance?
A.
lock out user sessions and gather system statistics overnight
B.
gather system statistics after a performance issue has been reported
C.
gather system statistics for several hours when there is no workload
D.
gather system statistics for several hours during normal workload periods
E.
shut down any running applications prior to collection
D