Financial Management Tuning Example

This example describes tuning an HFM application server with 8 CPUs, 64 GB of RAM and hosting three HFM applications with only one of the three being used heavily; call this application CORP. The Oracle Hyperion Financial Management application server will be used for both consolidation and reporting activity.

When you install Financial Management, standard configuration settings are provided by default. You can view these default settings and modify them in the Settings module.

In this example, we need to keep the total of the MaxNumDataRecordsinRAM value to 60,000,000, and the total MaxDataCacheSizeinMB value to 9,000. Since two of the three applications are not heavily used, we will allow those two application to use default values, and tune the CORP application to take full advantage of the server resources.

MaxNumDataRecordsinRAM default value is 30,000,000, with two applications using defaults - that means CORP can have MaxNumDataRecordsinRAM set to 40,000,000.

MaxDataCacheSizeinMB default value is 4,500, with two applications using defaults - that means CORP can have MaxDataCacheSizeinMB set to 6,000.

The other value we would consider tuning specifically for CORP in this example would be:

MinDataCacheSizeInMB – setting to half the value of MaxDataCacheSizeinMB (3,000).

Since we are tuning at the application level for CORP and allowing the other two applications to use default values, we create overrides for CORP to use values different than the defaults. These would be the updates to the settings:

MaxNumDataRecordsinRAM (40,000,000)

MaxDataCacheSizeinMB (6,000)

MinDataCacheSizeinMB (4,000)

To update these configuration settings, select Navigate, then Administer, then Consolidation Administration, then System, and select Settings

For information on all configuration settings, see Available Configuration Settings.

for information on settings for large applications, see Financial Management Memory Settings for Larger Applications.