Oracle 11g Default Jobs
Oracle
11g
的自带的
Job
,使用
select
*
from
Dba_Scheduler_Jobs;
可查询到。
介绍如下:
1. ORA$AUTOTASK_CLEAN
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.
2. HM_CREATE_OFFLINE_DICTIONARY
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. ‘
3. DRA_REEVALUATE_OPEN_FAILURES
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’.
5. MGMT_STATS_CONFIG_JOB
This
is
an
OCM
Statistics
collection
job
created
in
ocmjb10.sql
by
running
‘ORACLE_OCM.MGMT_CONFIG.collect_stats’.
6. BSLN_MAINTAIN_STATS_JOB (
替换了
10G
的
GATHER_STATS job
)
This job
replaces the old GATHER_STATS job
. It is a compute statistics
job. 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.
7. XMLDB_NFS_CLEANUP_JOB
The job is created in xdbu102.sql and runs the procedure
dbms_xdbutil_int.cleanup_expired_nfsclients.