Skip to main content

Data & Intelligence

How To Speed Up Your Essbase Database Restructure

shutterstock_130154402_350In Essbase 11.1.2.2, Oracle added a configuration option to improve the performance of Essbase Block Storage database restructures.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

RESTRUCTURETHREADS is a setting you can add to your Essbase.cfg file to enable parallel restructure of BSO databases. The proper syntax taken from the Essbase Technical Reference is:

RESTRUCTURETHREADS [ appname [ dbname] ] n

Application and database are optional parameters and if omitted will apply to all BSO databases on the server. n specifies the number of threads to use for parallel processing the restructure.

I have seen tremendous improvements to dense restructures on systems with the horsepower to support this. I usually set the number of threads to half the total number of processor cores on the Essbase server. For example, if an Essbase server has four quad-core CPUs, I will set this to 8. I leave off the application and database when I have control over when the restructures will occur.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Cris Dunn

Cris Dunn is the manager of Perficient's EPM SupportNet practice which provides direct support for applications and infrastructure surrounding many organizations' EPM software implementations. He is also an Oracle University certified instructor and teaches everything around Essbase as well as the EPM installation and configuration classes. When he is not working, you will find Cris engaged in His church serving as the treasurer, musician, nursery worker, and, when necessary, toilet scrubber.

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram