Wednesday, January 23, 2013

New Jobs in Oracle 11g


1. ORA$AUTOTASK_CLEAN

The job is created by the 11g script catmwin.sql – Catalog script for
Maintenance Window catmwin.sql defines maintenance window and stats collection job.This job is an autotask repository data ageing job and deletes obsolete AUTOTASK repository data. The delete of this old data will be performed by the procedure ora$age_autotask_data which will be executed by the job.

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.

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 Recovery Advisor. In other words it is used to get assistance in case of loss or corruption of datafiles, redo log files or controlfiles.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

This job 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. RSE$CLEAN_RECOVERABLE_SCRIPT

This job is STREAMS related. It is created in execstr.sql and is new in 11.2. The script execstr.sql executes anonymous blocks for STReam. The job is responsible with the cleaning of recoverable scripts and calls  ‘ ‘sys.dbms_streams_auto_int.clean_recoverable_script;’.

9. SM$CLEAN_AUTO_SPLIT_MERGE

This job is STREAMS related. It is created in file execstr.sql and is new in 11.2 too. The job is responsible with the cleaning of auto split merge views.

Wednesday, January 23, 2013

New Jobs in Oracle 11g


1. ORA$AUTOTASK_CLEAN

The job is created by the 11g script catmwin.sql – Catalog script for
Maintenance Window catmwin.sql defines maintenance window and stats collection job.This job is an autotask repository data ageing job and deletes obsolete AUTOTASK repository data. The delete of this old data will be performed by the procedure ora$age_autotask_data which will be executed by the job.

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.

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 Recovery Advisor. In other words it is used to get assistance in case of loss or corruption of datafiles, redo log files or controlfiles.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

This job 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. RSE$CLEAN_RECOVERABLE_SCRIPT

This job is STREAMS related. It is created in execstr.sql and is new in 11.2. The script execstr.sql executes anonymous blocks for STReam. The job is responsible with the cleaning of recoverable scripts and calls  ‘ ‘sys.dbms_streams_auto_int.clean_recoverable_script;’.

9. SM$CLEAN_AUTO_SPLIT_MERGE

This job is STREAMS related. It is created in file execstr.sql and is new in 11.2 too. The job is responsible with the cleaning of auto split merge views.

My Blog List