Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"

hu May 29 22:00:00 2014

Setting Resource Manager plan SCHEDULER[0x310A]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Thu May 29 22:00:00 2014

Starting background process VKRM

Thu May 29 22:00:00 2014

VKRM started with pid=47, OS id= 8847602 

Thu May 29 22:00:02 2014

Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

Thu May 29 22:02:27 2014

Thread 1 advanced to log sequence  16574 (LGWR switch)

  Current log# 2 seq#  16574 mem# 0: +DATADG/kmis/onlinelog/group_2.1162. 845783427

  Current log# 2 seq#  16574 mem# 1: +DATADG/kmis/onlinelog/group_2.1163. 845783443

Thu May 29 22:02:44 2014

Archived Log entry 1634 added for thread 1 sequence  16573 ID 0x1ac8948a dest 1:

Thu May 29 22:04:38 2014

End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

Fri May 30 02:00:00 2014

Closing scheduler window

Closing Resource Manager plan via scheduler window

Clearing Resource Manager plan via parameter

Fri May 30 13:41:43 2014

看见上面

Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK" Tue Aug 28 22:03:13 2012 End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"  alert.log里每天早上六点和晚上22点都会添加这么一条记录。为什么会有这么个job？自己没有进行这样的sql tuning啊？是oracle自己进行的sql tuning？

是的 ，11G R2 不知道这个东西怎么出来的。也不知道怎么关闭。。。。。

dbms_scheduler.disable(name=>)

http://www.itpub.net/thread-1711948-1-1.html

Introduce of SQL Tuning Advisor

In Oracle Database 10g, Oracle introduced the Automatic Tuning Optimizer, which is the name given to the optimizer when it is running in the tuning mode instead of in the normal mode. In the normal mode, the optimizer creates an execution plan under strict time constraints. In the tuning mode, the optimizer is given more latitude to produce a better execution plan. The output of the optimizer isn’t an execution plan but recommendations for improvements along with a summary of the benefits you might expect by implementing those recommendations. Oracle offered the Automatic Tuning Optimizer for complex and high-load SQL statements.

The advisor’s goal is to target poorly written SQL statements