Hyperion Essbase (MOSC)

MOSC Banner

What triggers Essbase to alter the commit block interval during a calculation script?

in Hyperion Essbase (MOSC) 5 commentsAnswered ✓

Essbase 11.2.4

When examining the duration that shell script ran and comparing the results in a staging, quality assurance and production environment, I observed a wide swing in the time the same script took to execute. The production environment ran the quickest. The log showed that while executing a calculation script triggered by a MAXL command, the Essbase agent modified the commit block setting from 3000 to 100000. This did not happen in the staging or quality assurance environment.

In the ESSBASE DBA guide, there is a note about the commit threshold stating that Essbase automatically increases the threshold to 10 MB if the setting requires less that 10 MB be written before an internal commit. What I am trying to determine is why this happens in one environment, but not the others despite similar servers.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center