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

abstractcyj發表於2016-04-03
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章