내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
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
'ORACLE > Admin' 카테고리의 다른 글
오라클 19c RDA(Remote Diagnostic Agent) 사용 가이드 (0) | 2020.08.09 |
---|---|
오라클 일반 테이블과 blob 테이블 생성, 데이터 삭제 후 datapump 테스트 (0) | 2020.08.01 |
오라클 11g R2 diag collection 로그수집 가이드 (0) | 2020.07.24 |
Windows Server 2016 서버 정상종료 시 oracle shutdown 프로세스 (0) | 2020.07.15 |
오라클 11g R2 컴포넌트 설명 (0) | 2020.07.15 |