1

I am submitting 5 jobs using below code but 1 st jobs takes around an hour more than rest of 4 jobs although number of records processed are same.

loop
  V_SEQID := V_SEQID + 1;
  DBMS_JOB.SUBMIT(jobNUMBER, 'package_name.'||v_process||'('||l_processid||','''||i_currentrundate||''','''||l_userid||''','''||automanualflag||''','''||l_machinename||''','||i_seqid||','||v_seqid||','||v_min||','||v_sequenceidto||','||v_Batchno||','||G_batch_seq_no||','''||l_tab_delimiter||''');',
                  SYSDATE,
                  NULL,
                  FALSE);
end loop;
Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
Atif
  • 2,011
  • 9
  • 23
  • 1
    The first step is to convert from DBMS_JOB to DBMS_SCHEDULER. With DBMS_SCHEDULER you will have much more debugging information, like DBA_SCHEDULER_JOB_RUN_DETAILS. It's possible that Oracle limits the number of jobs run, but you need a history table to know which job ran when. – Jon Heller Oct 03 '19 at 01:36
  • Thanks @JonHeller. We will definitely move to DBMS_SCHEDULER.I am able to identify the actual issue. We are dividing the job on the basis of sequential record due to which load is not getting divided equally as stating records have to do more processing as compared to latter records(newer records). Hence now I have divided the records on mix basis using mod fucntion. – Atif Oct 06 '19 at 04:40

0 Answers0