Essbase developers! Mind your WORKERTHREADS in 11.1.2.4

Hello Devs! With 11.1.2.4 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 11.1.2.4.000, 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.

threads

For more information please see the below technical reference.

Technical Reference: Click Here