Hi all,
We have an Oracle 11.2.0.3 database migrated from 10.2.0.4 in a 3-node RAC environment (migration was not in my scope)
.
While analysing a lock situation I found that two system jobs are running at the same time and possibly blocking each other:
select log_id,owner,job_name,status,actual_start_date,instance_id from dba_scheduler_job_run_details
where job_name = 'GATHER_STATS_JOB' and ACTUAL_START_DATE>SYSDATE-3
or job_name like 'ORA$AT_OS_OPT_SY%' and ACTUAL_START_DATE>SYSDATE-3
order by log_date desc;
LOG_ID OWNER JOB_NAME STATUS ACTUAL_START_DATE INSTANCE_ID
30576035 SYS GATHER_STATS_JOB SUCCEEDED 22.01.14 22:42:51,987543000 EUROPE/PARIS 1
30576029 SYS ORA$AT_OS_OPT_SY_6030 SUCCEEDED 22.01.14 20:00:02,897337000 EUROPE/PARIS 1
30596038 SYS GATHER_STATS_JOB STOPPED 22.01.14 20:00:01,313345000 EUROPE/PARIS 3
30571784 SYS GATHER_STATS_JOB SUCCEEDED 21.01.14 20:00:02,784593000 EUROPE/PARIS 1
30571781 SYS ORA$AT_OS_OPT_SY_6028 SUCCEEDED 21.01.14 20:00:02,667501000 EUROPE/PARIS 1
30547398 SYS GATHER_STATS_JOB SUCCEEDED 20.01.14 20:00:01,789890000 EUROPE/PARIS 3
30547384 SYS ORA$AT_OS_OPT_SY_6026 SUCCEEDED 20.01.14 20:00:03,106244000 EUROPE/PARIS 1
As far as I have researched, GATHER_STATS is the Oracle 10 scheduler job while the ORA$AT_... is the Oracle 11 autotask job.
My question:
Is there an important difference between the two jobs? Or (asking in another way): Do I need both jobs or would it be wise to disable the GATHER_STATS?
Thanks for some insight!
BH