sysman EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS() 这个任务是和EM 相关的任务,在数据库中频率为1分钟一次,如果碰到异常问题,容易引起性能问题,所以在用不到em的数据库中,可以禁掉
--查看EM使用端口,默认是1158和3938
cd $ORACLE_HOME/install
more portlist.ini
iSQL*Plus HTTP port number =5560
iSQL*Plus HTTP port number =5560
Enterprise Manager Console HTTP Port (testa) = 1158
Enterprise Manager Agent Port (testa) = 3938
--确认em端口没有在用
netstat -tnlp |grep 1158
netstat -tnlp |grep 3938
--查看dbconsole状态,确认em是关闭的状态
emctl status dbconsole
TZ set to PRC
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG = "AMERICAN_AMERICA.ZHS16GBK"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://testa:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
--如果EM开启并可关闭,关闭EM
emctl stop dbconsole
--删除sysman下em收集信息任务,这部操作需要用sysman用户登录。如果不记得sysman用户密码,可以修改。
EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
alter user sysman identified by oracle;
--logon as sysman
删除 emd_maintenance包
exec sysman.emd_maintenance.remove_em_dbms_jobs;
commit;
--查询dba_jobs确认job已删除