(610)Which of the following advisors is run in every maintenance window by the auto-task system?
SYS@ ysdb2>select operation_name from dba_autotask_operation;
OPERATION_NAME
----------------------------------------------------------------
auto optimizer stats job
auto space advisor job
automatic sql tuning task
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/