Hello everyone,
I met a problem with GATHER_STATS_JOB which has blocked me for several days.
The tracking is:
SQL> exec DBMS_SCHEDULER.RUN_JOB('GATHER_STATS_JOB',TRUE);
BEGIN DBMS_SCHEDULER.RUN_JOB('GATHER_STATS_JOB',TRUE); END;
*
ERROR at line 1:
ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1
I know there is something wrong with calling "merge into ..." somewhere in this job. But due to its owner is SYS, I shouldn’t go diving in the code to correct it.
What I've done:
Firstly, I dropped and recreated this job. But nothing is changed although everything went well while the recreation.
Secondly, I cleaned the statistics by EXEC DBMS_STATS.delete_database_stats,
Have you some ideas within my problem?
Thank you