ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 11g alert log中的automatic SQL Tuning及Resource Manager plan

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

原创 Linux操作系统 作者:tolywang 时间:2011-07-20 13:52:02 0 删除 编辑

今天在检查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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13475658