0 Replies Latest reply on Mar 20, 2013 10:14 PM by TPD-Opitz

    Jobs starting with delay


      in my application I'm starting jobs via dbms_scheduler for background activity on user action.

      I know from my logs that the procedure executed in the job finishes within 2 seconds.

      But in the AWR I find execution time for the job of 360 seconds (single execution because of unique job id).

      How do I find out why the job takes so long?
      And more important: how do I speed up the job?

      (details will follow...)