Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: jobs not starting in a timely fashion
It seems that this has been corrected in a patch from Oracle. I'm not
sure which one but over the weekend we patched it up to 8.1.7.3 and
every thing appears to be working correctly now.
altona_at_ditw.com (Alton) wrote in message news:<6d47b8a2.0205041004.3798023b_at_posting.google.com>...
> I'm using Oracle 8.1.7.0 on NT. I have a process that submits several
> (30 to 40) jobs to be run as soon as possible. My job_queue_processes
> is 4 and job_queue_interval is 20. What happens is that all the jobs
> are in the queue and 4 start running. Each of the jobs are "finished"
> at different times but seem to hang waiting for the longest job to
> finish. (I've checked to see if locks are the culprit but it doesn't
> seem so). After the 4 jobs are done and removed from the queue, there
> is about a 5 MINUTE delay before the next set starts. This continues
> until all the jobs are finished. I've checked all the things I know
> about over the last 2 or 3 weeks but can't find what's wrong. We went
> to 8.1.7 from 8.1.5 and this problem showed up. It worked fine on
> 8.1.5.
>
> Any insight will be appreciated.
>
> Thanks,
> Alton
Received on Mon May 06 2002 - 16:12:53 CDT