发现两个没见过的job:
    
    
    
    查看job:
   
SQL> select job_name from dba_scheduler_jobs;
    
    
    咋一看,就可以知道,这个JOB似乎并不是业务上的,因为schema是
    
     ORACLE_OCM
    
    肯定是Oracle自己的某个组件。查看有关资料~~~
    
    其实这个用户是Oracle 预定义的非管理员用户:
    
    
     ORACLE_OCM
    
    :
    
    The account used with Oracle Configuration Manager. This feature enables you to associate the configuration information for the current Oracle Database instance with OracleMetaLink. Then when you log a service request, it is associated with the database instance configuration information.
    
    See Oracle Database Installation Guide for your platform.
   
这个用户主要是用于Oracle配置管理器,当发出SR请求时,它和数据库实例配置相联系,把配置信息发送给Oracle供分析。默认情况下是过期或锁定的。
To verify if the OCM directories exist or not, run the following as sysdba:
SQL> set lin 160
SQL> col owner for a10
SQL> col DIRECTORY_NAME for a25
SQL> col DIRECTORY_PATH for a50
SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';
    
    
    由于OCM是一个独立工具,仅用于向MOS上传搜集信息,即使删除它不会对数据库造成影响,如果不使用OCM Collector, 可以从数据库中移除OCM对象或禁用OCM的jobs
   
# 如果不使用OCM Collector, 可以从数据库中移除OCM的对象。
SQL> drop user ORACLE_OCM cascade;
SQL> drop directory ORACLE_OCM_CONFIG_DIR;
SQL> drop directory ORACLE_OCM_CONFIG_DIR2;
# OCM 是一个独立的工具,移除OCM 不影响数据库其他功能的使用。
 
# 如果不删除OCM 的对象,也可以禁用OCM的jobs,命令如下:
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');
    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,还可参考:
10G中,GATHER_STATS_JOB这个自动任务默认情况下在工作日晚上10:00-6:00和周末全天开启. disable它的原因。
 
