Re: restricting use of job queues

Rob Cowell wrote:
>
> We're using Discoverer batch processes which schedule using DBMS_JOB. To
> prevent too many running at any one time I've set job_queue_processes to
> just 2. However now I want to start regular materialized view refreshes
> but some Discoverer jobs take more than an hour to run and hold onto the
> job queue process. I'm not sure that resource groups are going to help
> here, I've never had much luck with them though! Any thoughts? This is
> all on 8.1.7.4 btw. Thanks.

How about allowing submission in the normal way but writing your own job processing routine which does something with 2 children:

• child 1 looks for materialised view jobs
• child 2 does discoverer jobs

or something like that. clunky but possibly effective

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

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