Oracle自動維護任務

最近看到alter日誌裡面有VKRM的報錯資訊，所以查詢學習了下。
 
From Oracle 11g, each day has its own windows and each of it has been specified default resource plan.This is something new for me too.So, i think that would be reason for seeing VKRM process in the alert log.
 
 
 
SQL> select WINDOW_NAME,RESOURCE_PLAN from DBA_SCHEDULER_WINDOWS;
 
 
 
WINDOW_NAME                    RESOURCE_PLAN
 
------------------------------ ------------------------------
 
MONDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
 
TUESDAY_WINDOW                DEFAULT_MAINTENANCE_PLAN
 
WEDNESDAY_WINDOW              DEFAULT_MAINTENANCE_PLAN
 
THURSDAY_WINDOW                DEFAULT_MAINTENANCE_PLAN
 
FRIDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
 
SATURDAY_WINDOW                DEFAULT_MAINTENANCE_PLAN
 
SUNDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
 
WEEKNIGHT_WINDOW
 
WEEKEND_WINDOW
 
 
 
SYS@>AppD> SELECT WINDOW_GROUP_NAME,ENABLED,NEXT_START_DATE,COMMENTS FROM DBA_SCHEDULER_WINDOW_GROUPS
 
 
 
WINDOW_GROUP_NAME              ENABL NEXT_START_DATE                          COMMENTS
 
-------------------------- ----------------------------------------  --------------------------------------
 
MAINTENANCE_WINDOW_GROUP      TRUE  14-MAR-11 10.00.00.000000 PM  Window group for Automated Maintenance
 
ORA$AT_WGRP_OS                TRUE  14-MAR-11 10.00.00.000000 PM  auto optimizer stats collection
 
ORA$AT_WGRP_SA                TRUE  14-MAR-11 10.00.00.000000 PM  auto space advisor
 
ORA$AT_WGRP_SQ                TRUE  14-MAR-11 10.00.00.000000 PM  sql tuning advisor
 
 
 
SQL> select client_name ,status from DBA_AUTOTASK_CLIENT;
 
 
 
CLIENT_NAME                                                      STATUS
 
---------------------------------------------------------------- --------
 
auto optimizer stats collection                                  ENABLED
 
auto space advisor                                              ENABLED
 
sql tuning advisor                                              ENABLED
 
 
 
自動維護任務是一種按規則自動啟動的資料庫維護操作任務。比如自動收集為查詢最佳化工具使用的統計資訊。自動維護任務按維護視窗自動運行。所謂自動維護視窗是按照預定義的間隔時間視窗。

1 2 3 下一頁