Essbase developers! Mind your WORKERTHREADS in

Hello Devs! With WORKERTHREADS are no longer dynamically assigned when in parallel processing.

Historically, Essbase dynamically created threads for parallel operations such as parallel calculation, parallel data load, and parallel restructure. However, beginning in Release, the following parallel operations do not dynamically create threads, but instead use a set number of threads from a pre-created pool of threads:

  • Parallel calculation, with CALCPARALLEL or FIXPARALLEL
  • Parallel data load, for aggregate storage and block storage databases
  • Parallel export, for block storage databases
  • Parallel restructuring

Oracle recommends the following settings, depending on your system architecture.


For more information please see the below technical reference.

Technical Reference: Click Here

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s