X

Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers the Infra, functional, updates, release and articles...

  • 2. EPM |
    Friday, January 30, 2015

Essbase BSO Parallel Calculation and Calculator Cache

By: Jane Story | Senior Principal Applications Specialist - Customer Engineering & Advocacy Lab (CEAL Team)

Essbase BSO
parallel calculation utilizes calculator cache on a per thread basis. This post is to show the relationship between
using parallel calculation and calculator cache.

For calc parallel and calculator (calc)
cache:

  • Calc Parallel specifies the number of threads per calculation execution
  • Calc Cache is memory used per thread

If your calculations contain, for example,
CALCPARALLEL 9 and 5 users run this script, then (9 threads * 5 users) = 45 concurrent
threads will be used (assuming 45 threads are available and the content of the
calculation does not force serial calculation). If threads are not available, the calculations will wait until threads
are available.

If your CALCCACHEHIGH is set to 2 MB (as an example) then every thread will use 2
MB i.e. (9 threads * 5 users) = 45 concurrent
threads * 2 MB calc cache per thread, would mean that up to 90 MB of memory
would be used for these 5 concurrent calculations.

Although, in some circumstances, it may be
possible to increase these settings, it is important to be aware of this memory
usage and thread availability when considering use of calc parallel and calc
cache with applications, especially with applications that have high user
concurrency.

Testing should be performed to prove that
performance improvement outweigh the additional memory requirements.

Please see the following documentation for
more details on calc parallel and calculator cache:

Calc Parallel:

http://docs.oracle.com/cd/E40248_01/epm.1112/essbase_tech_ref/set_calcparallel.html

Sizing the Calculator Cache:

http://docs.oracle.com/cd/E40248_01/epm.1112/essbase_db/frameset.htm?dstcache.html

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services