You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Parallel Job Execution and EXECUTION_POOL_SIZE in Oracle EPM Pipelines

edited Nov 25, 2025 7:12PM in EPM Platform and Freeform

Summary:

Hello Everyone,

I am currently working with pipelines in Oracle EPM Freeform and need some clarification. We are looking to optimize performance and would like to better understand the safer limits and recommended practices for configuring parallelism in pipelines.

1.Has anyone attempted to run the maximum number of parallel jobs (25) within an EPM pipeline? If so, what was the outcome?

2.We use the EPM Agent to pull data from our source system, and the agent configuration file includes a parameter called EXECUTION_POOL_SIZE. Oracle documentation notes a default value of 2 but does not mention the maximum. From what we understand, this parameter defines how many jobs can run in parallel during pipeline execution. Can this value be set to 25 when the pipeline allows 25 parallel jobs? If so, what effect could this have on the system’s overall performance?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!