What batch parameter size do you recommend for Open Enrollment scheduled job supporting 97K emps?
Summary:
We are seeking a recommendation for the appropriate batch parameter size for an Oracle HCM Cloud Open Enrollment scheduled processes supporting a client population of approximately 97,000 employees. This should consider system performance, processing time, resource utilization, and potential impacts on other scheduled processes or users. Include any relevant Oracle best practices and testing considerations.
Content (please ensure you mask any confidential information):
Currently the processes are running very slow after using below batch size:
Threads 100
Chunk size 800
Max Errors allowed 10,000
Version (include the version you are using, if applicable):
26B (11.13.26.04.0)
Code Snippet (add any code snippets that support your topic, if applicable):