You have the following requirements with respect to optimizer statistics:
The statistics should be generated automatically during weekdays (Monday to Friday)
between 10:00 p.m. and 7:00 a.m. The objects that need updated statistics the most should
be processed first. What would you do?
A.
Modify the AUTO_TASKS_JOB_CLASS Scheduler class.
B.
Use the DBMS_STATS.GATHER_DATABASE_STATS procedure with the GATHER
AUTO option.
C.
Not make any modifications, because by default the WEEKNIGHT_WINDOW scheduler
window automatically generates statistics during weekdays between 10:00 p.m. and 7:00
a.m.
D.
Modify the duration of the default WEEKNIGHT_WINDOW scheduler window to 10:00
p.m.?:00 a.m.