Oracle Job Waiting Database link

Problem:

Job all parameters are normal, but is not running, found that the execution time is one months ago:

JOB            6                   log_user       user                   priv_user      user                  schema_user    user                  last_date      2014-12-26 15:31:49   last_sec       15:31:49              this_date      2014-12-26 15:32:49   this_sec       15:32:49              Next_date      2014-12-26 15:32:49   next_sec       15:32:49              total_time     4398944               broken         N                     INTERVAL       sysdate+1/24/60       failures       0                     what           proc_connect;   Nls_env        nls_language= ' simplifimisc_env       0102000200000000      INSTANCE       

　　

Looking at the job being executed, it was found that the job had been running since one months ago, and that the job was actually executed 10 seconds before it ended.

SELECT * FROM DBA_JOBS_RUNNINGSIDJOBFAILURESLAST_DATELAST_SECTHIS_DATETHIS_SECINSTANCE1003602014/12/26 10:21:49.00010:21:492014/12/26 10:22:49.00010:22:490

　　

Query Wait Events:

Wait from Dblink

Query Lock:

Traction

Results:

The discovery is that Dblink failure causes the job to remain unfinished and not released.

Oracle Job Waiting Database link