Hello Devs! With 22.214.171.124 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 126.96.36.199.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.
For more information please see the below technical reference.
Technical Reference: Click Here