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,

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-l


Received on Thu May 25 2023 - 11:23:46 CEST

Original text of this message