Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Consolidation performance

993723May 31 2013 — edited Jun 13 2013
Dear Experts,

I am aware of MaxNumDataRecordsInRAM and MaxDataCacheSizeinMB settings.
Having bumped up those settings to upper values (40M and 6000 currently), we can see during busy times HFM application (Hsvdatasource.exe) can take 30 GB of 32 GB RAM in the application server. Performance tuning guide suggests we could even increase more like 60M and 9000 if we have 32 GB of RAM given that only memory intensive application is HFM as in our case.

can you please share your experience for those parameters ? is it possible to improve consolidation speed by focusing more on those parameters or else ?

Best Regards,

Comments

thatJeffSmith-Oracle

If you export the same data/query to another format like CSV, is the data integrity maintained there? Just trying to localize this to JUST XLS exports or a bigger problem in general.

Ora-aff

I just checked and found that the report is exported correctly in the XLS and CSV, it is only when I convert .xls into OpenOffice Spreadsheet, the data integrity is lost.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 11 2013
Added on May 31 2013
2 comments
524 views