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
Answer: B
参考: http://blog.itpub.net/17013648/viewspace-1326757/
三种自动任务:存储空间,优化器统计信息,SQL自动调整
SQL> 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
Answer: B
参考: http://blog.itpub.net/17013648/viewspace-1326757/
三种自动任务:存储空间,优化器统计信息,SQL自动调整
SQL> 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/8520577/viewspace-2074452/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2074452/