Oracle OCP 1Z0 053 Q610( auto-task in maintenance window)
时间：2023-10-03 02:37:01
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-如需转载，请注明出处，否则将追究法律责任。
