053-270

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor

  自动维护:是在建数据库时动创建的,并由度程序行管理。默情况下,它会收集数据化程序统计信息缺失或已过时的所有象的统计信息。可以通过“Automatic Maintenance Tasks(自动维护” 页更改默配置。
  默认设置:
    优化程序统计信息搜集
    段指导
    自动SQL优化

原文地址:https://www.cnblogs.com/Babylon/p/7850605.html