Oracle 11G OCP 1Z0-053 610

（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博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1326757/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1326757/