Re: Running jobs in job queue immediately

Ryan Gaffuri wrote:
>
> I want to use my job queue for parallel processing and run up to 36
> jobs at once. Im using now for stress testing, but in the future I
> want to run batch deltas from stage to master tables in parallel. For
> example, I have to do inserts,updates,and deletes on the same table
> then analyze the table. I want to put the insert,update,and delete
> algorithm into the job queue and run them all at once, then wait for
> the job to finish and analyze the table(this is easily done with
> DBMS_ALERT).
>
> right now I am running a script that adds 46 jobs to the job queue. It
> commits after each job is place in the queue from with in a cursor(im
> not worried about performance so ignore the commit in the cursor).
>
> job_queue_processes = 36
> job_queue_interval = 60
>
> Some of these jobs get executed immediately, some wait and wait to
> enter the queue even when there are 8-10 jobs running at once. How do
> I get the queue to hit 36 jobs and add a new job as soon as there is a
> free process?

Options

1. shrink your job interval
2. use 9i where the job interval concept is removed

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"