Oracle 11g自带的系统Job介绍

绝地灬酷狼 2022-08-09 17:36 270阅读 0赞

[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.

8.下面的视图显示有关自动数据库维护任务的信息：  
select \* from DBA\_AUTOTASK\_CLIENT\_JOB;  
select \* from DBA\_AUTOTASK\_CLIENT;  
select \* from DBA\_AUTOTASK\_JOB\_HISTORY;  
select \* from DBA\_AUTOTASK\_WINDOW\_CLIENTS;  
select \* from DBA\_AUTOTASK\_CLIENT\_HISTORY;

\--------------------------------------------------------------------------------------

另，关于Oracle 系统job,还可参考：

1.[鸡肋-ORACLE**10g**自动收集CBO统计信息][-ORACLE_10g_CBO]

10G中,GATHER\_STATS\_JOB这个自动任务默认情况下在工作日晚上10：00-6：00和周末全天开启. disable它的原因。

2.[Oracle 10g GATHER\_STATS\_JOB造成大量的db file scattered read等待事件][Oracle 10g GATHER_STATS_JOB_db file scattered read]

将10G中自带的job执行时间调整到每天临晨2点到8点...

3.[Oracle 11g新特性之统计信息收集-性能调优][Oracle 11g_-]

[Oracle 11g Default Jobs]: http://www.asktherealtom.ch/?p=147
[-ORACLE_10g_CBO]: http://www.eygle.com/archives/2007/12/dbms_scherduler_disable.html
[Oracle 10g GATHER_STATS_JOB_db file scattered read]: http://www.elcaro.cn/?p=64
[Oracle 11g_-]: http://www.bitscn.com/pdb/oracle/200807/146636.html