Oracle 10g Default Scheduler Jobs
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