Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GATHER_STATS_JOB ORA-30926: unable to get a stable set of rows in the source tables

linnnnaJun 12 2015 — edited Jun 14 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2015
Added on Jun 12 2015
12 comments
477 views