Oracle Release Version 12.1.0.2.0 Production
During installation we have disable auto maintenance window . Now we have enable gather stats within maintenance window.
Getting error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_462"
ORA-02149: Specified partition does not exist
ORA-06512: at "SYS.DBMS_STATS", line 44284
select client_name,JOB_NAME,JOB_STATUS,JOB_START_TIME,JOB_DURATION from DBA_AUTOTASK_JOB_HISTORY where JOB_START_TIME >systimestamp -7 and client_name='auto optimizer stats collection'
CLIENT_NAME | JOB_NAME | JOB_STATUS JOB_START_TIME | JOB_DURATION |
----------------------------------- -------------------- ---------- ---------------------------------------- ---------------
auto optimizer stats collection | ORA$AT_OS_OPT_SY_442 FAILED | | 05-MAY-15 10.00.02.798809 PM EUROPE/AMSTERDAM +000 00:01:18 |
auto optimizer stats collection | ORA$AT_OS_OPT_SY_462 FAILED | | 06-MAY-15 10.00.04.956430 PM EUROPE/AMSTERDAM +000 00:01:18 |
| | | |
| |
select actual_start_date,job_name,status,run_duration,error# from dba_scheduler_job_run_details where job_name like '%OPT%' order by log_date;
ACTUAL_START_DATE | JOB_NAME | STATUS | RUN_DURATION ERROR# |
--------------------------------------------------------------------------- -------------------- ------------------------------ --
05-MAY-15 10.00.02.798809 PM EUROPE/AMSTERDAM | ORA$AT_OS_OPT_SY_442 FAILED | +000 00:01:18 2149 |
06-MAY-15 10.00.04.956430 PM EUROPE/AMSTERDAM | ORA$AT_OS_OPT_SY_462 FAILED | +000 00:01:18 2149 |
Due to this stats are not gathere..Need fix for same.