I have a question regarding the way the Oracle job queue processes are used by IFS.
I have noticed in other posts the number of job_queue_processes should be initialized at number of IFS batch queues + 5 and that is what has been set up for my customer.
But what we have noticed is that even if several jobs are posted in different IFS batch queues they are not all executed in parallel.
For example we have 17 queues in IFS and have set up the job_queue_processes to 22 in the oracle database.
We had at least 6 queues with several lines in state Posted.
But when checking at the execution of the queues we never had more than 3 jobs running at the same time. I know some jobs can be executed very fast but when checking at the latest executed job on some of the queues it could happen that none of the jobs has been executed for about 1 hour.
I assume that this is due to the ressources the current executed jobs are consuming and that the database has to be sized correctly but I would like to know how IFS is handling the way he sends the jobs to the Oracle queues and why we don’t have more executed jobs at the same time.