RLM$SCHDNEGACTION 執行導致負載問題

在監控系統上發現系統 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