今天检查数据库的定时任务的时候发现了如题所示的JOB:EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS()。
具体情况如下:

该JOB每分钟执行一次,为EM收集需要的信息。

该JOB具体会做下面这几件事情:
The EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS job performs all the necessary maintenance tasks for the database control repository. These tasks include :

+ Agent Ping Verification (EM_PING.MARK_NODE_STATUS)
+ Job Purge (MGMT_JOB_ENGINE.APPLY_PURGE_POLICIES)
+ Metric Rollup (EMD_LOADER.ROLLUP)
+ Purge Policies (EM_PURGE.APPLY_PURGE_POLICIES)
+ Repository Metric Severity Calculation (EM_SEVERITY_REPOS.EXECUTE_REPOS_SEVERITY_EVAL)
+ Repository Side Collections (EMD_COLLECTION.RUN_COLLECTIONS)
+ Send Notifications

它会导致系统的IO增大。

对EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS()的一些操作(最好使用sysman用户执行以下操作):
启用:
EXEC DBMS_JOB.BROKEN(job#,FALSE);
commit;

停止:
EXEC DBMS_JOB.BROKEN(job#,TRUE);
commit;

删除emd_maintenance包:
exec sysman.emd_maintenance.remove_em_dbms_jobs;
commit;

删除emd_maintenance的JOB:
dbms_job.remove(job#);
commit;

————————————————————————————————————
Done。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装