프린트 하기

내맘대로긍정이 알려주는

Oracle 23ai 신기능
무료 세미나 발표자료

다운로드 trending_flat

OS환경 : Oracle Linux 6.8 (64bit)


DB 환경 : Oracle Database 11.2.0.4


방법 : 오라클 11g 의 새로운 Job


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.



해당 job 들은 dba_scheduler_jobs에서 확인가능함

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SQL> select job_name from dba_scheduler_jobs;
 
JOB_NAME
------------------------------
SM$CLEAN_AUTO_SPLIT_MERGE
RSE$CLEAN_RECOVERABLE_SCRIPT
FGR$AUTOPURGE_JOB
BSLN_MAINTAIN_STATS_JOB
DRA_REEVALUATE_OPEN_FAILURES
HM_CREATE_OFFLINE_DICTIONARY
ORA$AUTOTASK_CLEAN
FILE_WATCHER
PURGE_LOG
MGMT_STATS_CONFIG_JOB
MGMT_CONFIG_JOB



참조 : http://kannan-oracle.blogspot.com/2013/01/new-jobs-in-oracle-11g_23.html

Doc. 755838.1, 466682.1