Database Administration (MOSC)

MOSC Banner

10g database scheduled job does not finish

edited Aug 28, 2013 10:29PM in Database Administration (MOSC) 6 commentsAnswered
Hello.
I had one job that was working succesfully but suddenly (no changes in source code or huge data insertions) the job does not finish.
It used to last about 20 min to finish.

This is the info I have gathered:

select * from dba_jobs_running;

       SID        JOB   FAILURES LAST_DATE LAST_SEC THIS_DATE THIS_SEC   INSTANCE
---------- ---------- ---------- --------- -------- --------- -------- ----------
      2057        140          0 13/08/13  04:14:27 26/08/13  13:45:06          2



SQL> select sql_fulltext
  2  from v$sql
  3  where sql_id = '8phdnygh4mpt9';

SQL_FULLTEXT
--------------------------------------------------------------------------------
SELECT /*+ INDEX(a  WF_PK_DET_TRAMITES) */ VALOR FROM WF_DETALLES_TRAMITES A WHE
RE A.ID_TRAMITE = :B5 AND ID_ETAPA_PROCESO = :B4 AND NOMBRE_FUNCION = :B3 AND NO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center