Ask The Real Tom

September 22, 2009

Oracle 11g Default Jobs

Filed under: oracle — Tags: , , — admin @ 8:15 am

The job is created by the 11g script catmwin.sql which mentions that this job is an autotask repository data ageing job. It runs the procedure ora$age_autotask_data.

The job is created by the 11g script catmwin.sql which mentions that this is a job for creation of offline dictionary for Database Repair Advisor.

The system job SYS.HM_CREATE_OFFLINE_DICTIONARY executes the dbms_hm.create_offline_dictionary package which creates a LogMiner offline dictionary in the ADR for DRA name translation service. The job for generating the logminer dictionary is scheduled during the maintenance window. This job can be disabled. ‘

The job is created by the 11g script catmwin.sql which mentions that this is a job for reevaluate open failures for Database Repair Advisor.
The job executes the procedure dbms_ir.reevaluateopenfailures.

4. MGMT_CONFIG_JOB – comes with the OCM(Oracle Configuration Manager) installation – This is a configuration collection job.

The job is created by the script ocmjb10.sql by running procedure ‘ORACLE_OCM.MGMT_CONFIG.collect_config’.

This is an OCM Statistics collection job created in ocmjb10.sql by running ‘ORACLE_OCM.MGMT_CONFIG.collect_stats’.

This job runs theĀ  BSLN_MAINTAIN_STATS_PROG program on the BSLN_MAINTAIN_STATS_SCHED schedule. The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline’s statistics up-to-date.

The job is created in xdbu102.sql and runs the procedure dbms_xdbutil_int.cleanup_expired_nfsclients.


  1. How BSLN_MAINTAIN_STATS_JOB is different from Automatic Maintenance Jobs that performs
    1. Automatic Optimizer Statistics Collection
    2. Automatic Segment Advisor
    3. Automatic SQL Tuning Advisor

    Comment by Sharad — June 13, 2010 @ 10:47 am

  2. When You wont disable gather stats job in oracle 11g, then You must disable ORA$AUTOTASK_CLEAN from dba_scheduler_job.

    Comment by xxx — August 3, 2011 @ 9:05 am

  3. BSLN_MAINTAIN_STATS_JOB definitely does not replace old GATHER_STATS_JOB. Do you really think you are the real TOM???

    Comment by Pavol Babel — August 3, 2011 @ 9:12 am

  4. No. The auto task BSLN_MAINTAIN_STATS_PROG collects/updates the moving window baseline. – The statistics are gathered by GATHER_STATS_PROG (if you use let the auto task enabled).

    This are just autotask which are per default enabled.
    For many small development (or small produciton) databases the auto task GATHER_STATS_PROG is sufficient for statistic gathering.

    Comment by admin — August 4, 2011 @ 12:54 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress