While using buffer cache advisory, you find that no statistics have been collected. Which
task would you perform to collect the statistics?
A.
Create a custom Automatic Database Diagnostic Monitor (ADDM) task.
B.
Set STATISTICS_LEVEL to TYPICAL.
C.
Set TIMED_OS_STATISTICS to 100.
D.
Set TIMED_STATISTICS to TRUE.
E.
Set ACTIVE_INSTANCE_COUNT to 2.
F.
Wait for the default automatic optimizer statistics generation.
G.
Set DB_CACHE_ADVICE to ON.
H.
Modify the AUTO_TASKS_JOB_CLASS schedule class.
I.
Restart the database instance.