Oracle OCP 1Z0 053 Q610( auto-task in maintenance window)

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074452/，如需轉載，請註明出處，否則將追究法律責任。