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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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