Hyperion Essbase (MOSC)

MOSC Banner

Essbase Database Optimization Setting recommended

edited Sep 13, 2014 5:00AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi Everyone,

I was trying to Optimize Essbase cube and found few of the deciding factors as follows:

Data cache Size = 0.125*(sum of all exx......pag files of Essbase Cube)

Index Cache Size=Index file size of the Essbase cube

So the question here is how do i calculate the optimal Value for the following:

Committed block setting (default is 3000 blocks)

And other Settings or checks that will help me in Optimization of the Essbase Cube.

FYI

The Essbase App is BSO

Thanks & Regards

Deepak PS

Tagged:

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