You need to tune a block storage option database for calculations on a 32bit Essbase
server. Identify the two starting point tuning steps that you might take (assuming no direct
I/O).
A.
Set Index Cache the size of the index file
B.
Set Data Cache to the size of 0.125 * pag file
C.
Set Data File Cache to the size of .025 * data file
D.
Reset sparse and dense dimensions to achieve a block size greater than 100KB
Explanation:
http://forums.oracle.com/forums/thread.jspa?threadID=2171921&tstart=2