ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RLM$SCHDNEGACTION 运行导致负载问题

RLM$SCHDNEGACTION 运行导致负载问题

原创 Linux操作系统 作者:tolywang 时间:2011-02-16 11:56:36 0 删除 编辑
在监控系统上发现系统 schedule job 运行的如下两个package占用cpu较高 (95%左右), 而且持续一定时间,
简单查询,发现这两个package 应该是和Expression Filter 有关的, 是oracle10g中的特性, 安装数据库时候
的可选项, 典型安装不会包含。  

RLM$EVTCLEANUP
RLM$SCHDNEGACTION

每隔一个小时运行一次, 对负载有一定影响, 查询metalink 的解决方法是disable them by uninstalling the
EXFSYS schema  :

1. Login as SYSDBA
2. @$ORACLE_HOME/rdbms/admin/catnoexf.sql


问题点:
1.   这两个packages具体是干什么用的,为什么有必要每小时运行一次(默认) ?
2.   uninstall  EXFSYS schema 是否对数据库有其他方面的影响 ?  




Metalink 查询到的一些信息 :  


What Are These RLM$% Jobs
In Enterprise Manager, Database, Administration, Jobs (under 'Scheduler'), we find the following jobs:
1. RLM$EVTCLEANUP
Command Type PL/SQL Block
PL/SQL       begin dbms_rlmgr_dr.cleanup_events; end;
2. RLM$SCHDNEGACTION
Command Type PL/SQL Block
PL/SQL       begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end;


They both run hourly and are under schema 'EXFSYS'. What are these jobs and how to disable them?


Solution
These jobs under EXFSYS schema are related to the Expression Filter feature in 10G.
The Expression Filter feature can be installed on an Oracle10G Standard or Enterprise Edition
database. It is supplied as a set of PL/SQL packages, a Java package, a set of dictionary tables,
and catalog views. All these objects are created in a dedicated schema named EXFSYS. This schema
is not part of the typical installation of the database and will not exist before the Expression
Filter is installed.

You can disable them by uninstalling the EXFSYS schema as follows:

1. Login as SYSDBA
2. @$ORACLE_HOME/rdbms/admin/catnoexf.sql

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-687321/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13471913