EPM 11.1.2 - Increase Retrieval Buffer Sizes for Essbase (ASO/BSO)
By Ahmed Awan-Oracle on Dec 07, 2011
- Set Retrieval Buffer Size to 50 KB for 32 bit platform and 100 KB for 64 bit platform.
Set Retrieval Sort Buffer Size to 50 KB for 32 bit platform and 100 KB on 64 bit platform: Essbase requires a larger retrieval sort buffer size on 64-bit platforms than on 32-bit platforms.
Important Note: If you have a high-memory-use installation (Essbase 64bit), you can configure higher retrieval buffer values (i.e. 300KB). Caution: It is recommended to start with default values and a test incremental setting on largest report tuning is based on. As this setting is per user report request so it may lead to wastage of memory and only want to set as much as needed. Also note the retrieval buffer is allocated per thread, so the amount of memory needed is the number of server threads multiplied by the retrieval buffer size.