Ask The Real Tom

January 21, 2009



Oracle 10g Default Scheduler Jobs

Filed under: Uncategorized — Tags: , , , — admin @ 11:10 am

Maybe you wonder what these jobs in your 10.2 installation do:

SQL> select job_name,state,JOB_CREATOR,JOB_ACTION,NUMBER_OF_ARGUMENTS from dba_scheduler_jobs;

JOB_NAME           STATE           JOB_CREATOR           JOB_ACTION
---------------------------- ------------------------------------------------------------
PURGE_LOG                        SCHEDULED       SYS
FGR$AUTOPURGE_JOB           DISABLED         SYS sys.dbms_file_group.purge_file_group(NULL);0
GATHER_STATS_JOB            SCHEDULED       SYS
AUTO_SPACE_ADVISOR_JOB  SCHEDULED       SYS
RLM$EVTCLEANUP                SCHEDULED       SYS begin dbms_rlmgr_dr.cleanup_events; end;
RLM$SCHDNEGACTION          SCHEDULED       SYS begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end;

The RLM$ are related to the Expression Filter feature in 10G.
The can be disabled / removed with this script (as sysdba)
@$ORACLE_HOME/rdbms/admin/catnoexf.sql

Powered by WordPress