자동통계수집 job 돌고 있는지 확인

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 10.2.0.4

쿼리 : 자동통계수집 job 돌고 있는지 확인(10g)

select schedule_name, j.program_owner, j.program_name

     , p.program_action, p.number_of_arguments

     , cast(j.last_start_date as timestamp with local time zone) last_start_date

     , last_run_duration, stop_on_window_close 

from   dba_scheduler_jobs j, dba_scheduler_programs p

where  j.job_name = 'GATHER_STATS_JOB'

and    p.program_name = j.program_name ;

결과값 : 

set lines 200

set pages 1000

col SCHEDULE_NAME for a25

col program_owner for a10

col program_name for a20

col program_action for a20

col NUMBER_OF_ARGUMENTS for 9

col last_start_date for a30

col last_run_duration for a26

select schedule_name, j.program_owner, j.program_name

     , p.program_action, p.number_of_arguments

     , cast(j.last_start_date as timestamp with local time zone) last_start_date

     , last_run_duration, stop_on_window_close 

from   dba_scheduler_jobs j, dba_scheduler_programs p

where  j.job_name = 'GATHER_STATS_JOB'

and    p.program_name = j.program_name ;

SCHEDULE_NAME             PROGRAM_OW PROGRAM_NAME         PROGRAM_ACTION       NUMBER_OF_ARGUMENTS LAST_START_DATE                     LAST_RUN_DURATION         STOP_

------------------------- ---------- -------------------- -------------------- ------------------- ----------------------------------- ------------------------- -----

MAINTENANCE_WINDOW_GROUP  SYS        GATHER_STATS_PROG    dbms_stats.gather_da                   0 14-MAY-18 10.00.01.228057 PM        +000000000 00:21:43.51167 TRUE

                                                          tabase_stats_job_pro                                                         0

                                                          c

                                                          

참조 :