（610）Which of the following advisors is run in every maintenance window by the auto-task system?

A. The Memory Advisor

B. The SQL Tuning Advisor

C. The Undo Advisor

D. The SQL Access Advisor

答案：（B）

解析：

Oralce 11g有3种预定义的自动维护任务，自动维护任务根据维护窗口自动运行：
SYS@ ysdb2>select operation_name from dba_autotask_operation;

OPERATION_NAME
----------------------------------------------------------------
auto optimizer stats job
auto space advisor job
automatic sql tuning task

ITPub博客

Oracle 11G OCP 1Z0-053 610

最新文章