Sometimes we have noticed performance drawbacks due to the value set for the "job queue processes” parameter in the oracle database. What is the correct formula for the set this value correctly and what are the things that need to consider?
Solved
Optimum value for job queue processes parameter
Best answer by Chathura Karunarathna
We can decide the optimum value for Job Queue Processes parameter using the below formula.
(TotalIFSBatchQueueProcesses + OracleReservedProcesses + 3) <= JobQueueProcesses
Once the value is decided please use the below command to set the value in the database.
Alter system set job_queue_processes=<value> scope=both;
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.