Suspending MMON slave action kewrmapsa_ for 82800 seconds

显示全部楼层 · 2012-10-9 18:05:07

alert.log
报以下错误
Suspending MMON slave action kewrmapsa_ for 82800 seconds系统缓慢。约40分钟。
产生这个错误后，系统就恢复正常。

千问 · 2012-10-9 18:05:07

本帖最后由 weixubin 于 2013-3-22 21:39 编辑
结贴：
http://www.itpub.net/thread-1597203-4-1.html
Solution
To disable the DEFAULT_MAINTENANCE_PLAN you can use the below steps as suggested in Note 786346.1
1. Set the current resource manager plan to null (or another plan that is not restrictive):
alter system set resource_manager_plan='';

2. Change the active windows to use the null resource manager plan (or other nonrestrictive plan)
using:3. Then, for each window_name (WINDOW_NAME from DBA_SCHEDULER_WINDOWS), run:
execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN',''); execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');