This discussion is archived
1 Reply Latest reply: Apr 24, 2013 11:51 PM by User477708-OC RSS

Procedure in a job takes less time to run when executed manually

user8916506 Newbie
Currently Being Moderated
I am using oracle 9.2.0.8 on RHEL 4.8 (64-bit). I am facing a strange problem. I have this one job in database that takes almost 12-15 minutes to execute but when I execute procedure in that job manually, it executes in one minute. Even when no other job is running in database, it takes more than 10 minutes to execute.
Any help in figuring out the cause of this problem will be of great help to me.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points