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

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-702629/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-702629/