job_priority for Oracle scheduler jobs
From: Fairlie Rego <fairlie.rego_at_gmail.com>
Date: Thu, 25 May 2023 19:23:46 +1000
Message-ID: <CAJEEaCz74rzAhyhFg_Uw63VbFfVds-ULXeNo1+rRfE2iR9ytFQ_at_mail.gmail.com>
Hi all,
Date: Thu, 25 May 2023 19:23:46 +1000
Message-ID: <CAJEEaCz74rzAhyhFg_Uw63VbFfVds-ULXeNo1+rRfE2iR9ytFQ_at_mail.gmail.com>
Hi all,
I am currently working on a system which is a heavy user of Oracle
scheduler jobs. During certain hours we have almost 20,000 jobs running in
an hour
and some critical ones do not seem to get kicked off at the exact time they
need to run.
Is anyone using the job_priority feature and if so in what version and have they faced any issues with it.?
*"When several jobs within the same job class are scheduled to start at the same time, the job coordinator uses the job priority to decide which job to execute first."*
[image: image.png]
Cheers
Fairlie
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 25 2023 - 11:23:46 CEST
- image/png attachment: image.png