11g alert log中的automatic SQL Tuning及Resource Manager plan

今天在檢查11g 系統的時候， 偶爾發現Oracle Log中有一些以前沒有見過的資訊， 貌似自動SQL Tuning及資源管理計劃 。 Log先貼在這裡   ,    繼續研究中...........  

Mon Jul 18 22:00:00 2011
Starting background process VKRM
Mon Jul 18 22:00:00 2011
VKRM started with pid=29, OS id=25584
Mon Jul 18 22:00:00 2011
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Mon Jul 18 22:00:20 2011
Thread 1 advanced to log sequence 177 (LGWR switch)
  Current log# 3 seq# 177 mem# 0: /data/hunetapp/redo03.log
Mon Jul 18 22:00:20 2011
Archived Log entry 103 added for thread 1 sequence 176 ID 0x4850121d dest 1:
Tue Jul 19 02:00:00 2011
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Jul 19 08:05:53 2011
Thread 1 advanced to log sequence 178 (LGWR switch)
  Current log# 1 seq# 178 mem# 0: /data/hunetapp/redo01.log
Tue Jul 19 08:05:53 2011
Archived Log entry 104 added for thread 1 sequence 177 ID 0x4850121d dest 1:
Tue Jul 19 20:52:39 2011
Thread 1 advanced to log sequence 179 (LGWR switch)
  Current log# 2 seq# 179 mem# 0: /data/hunetapp/redo02.log
Tue Jul 19 20:52:40 2011
Archived Log entry 105 added for thread 1 sequence 178 ID 0x4850121d dest 1:
Tue Jul 19 22:00:00 2011
Setting Resource Manager plan SCHEDULER[0x3108]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue Jul 19 22:00:00 2011
Starting background process VKRM
Tue Jul 19 22:00:00 2011
VKRM started with pid=31, OS id=1612
Tue Jul 19 22:00:02 2011
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Tue Jul 19 22:14:08 2011
Thread 1 advanced to log sequence 180 (LGWR switch)
  Current log# 3 seq# 180 mem# 0: /data/hunetapp/redo03.log
Tue Jul 19 22:14:08 2011
Archived Log entry 106 added for thread 1 sequence 179 ID 0x4850121d dest 1:
Thread 1 advanced to log sequence 181 (LGWR switch)
  Current log# 1 seq# 181 mem# 0: /data/hunetapp/redo01.log
Tue Jul 19 22:14:11 2011
Archived Log entry 107 added for thread 1 sequence 180 ID 0x4850121d dest 1:
Wed Jul 20 02:00:00 2011
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter