Thanks for the question, B.
Asked: March 20, 2025 - 3:32 pm UTC
Last updated: March 25, 2025 - 7:02 am UTC
Version: 19.1
Viewed 100+ times
You Asked
On my test database, Oracle scheduler seems a bit lethargic.
In my case, I am inserting data into 6 different tables ( million plus rows in each table ), these are done as insert into / select from via a stored procedure, I have a package with 6 procedures. In the package I create 6 jobs to do the insertion. At any given point only 4 jobs are running and they seem much slower then if I run these 6 procedures from a SQL Plus command line.
I created a new job class for these jobs and my job_queue_parameter is currently set to 160.
Is there something I can do to make these move faster via the scheduler ?
Thanks
BC,
CT,MI
and Connor said...
A couple things to look at
- Check DBA_SCHEDULER_RESOURCES to see if any constraints have been placed on the concurrency of scheduler job executions
- How max'd out is your machine? The scheduler proactively looks at load via Resource Manager and will try to avoid over-stressing the machine