自动维护任务是一种按规则自动启动的数据库维护操作任务。比如自动收集为查询优化器使用的统计信息。自动维护任务按维护窗口自动
最近看到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
自动维护任务是一种按规则自动启动的数据库维护操作任务。比如自动收集为查询优化器使用的统计信息。自动维护任务按维护窗口自动运行。所谓自动维护窗口是按照预定义的间隔时间窗口。
