Consider the simple case of 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 Financial Management application server will be used for both consolidation and reporting activity, and the database will be Oracle.
Referring to the table provided in the Financial Management Memory Settings for Larger Applications section, we need to keep the totals of MaxNumDataRecordsinRAM and MaxDataCacheSizeinMB to 60,000,000 and 9,000 respectively. 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 is 30,000,000, with two applications using defaults - that means CORP can have MaxNumDataRecordsinRAM set to 40,000,000.
Default value for MaxDataCacheSizeinMB is 4,500, with two applications using defaults - that means CORP can have MaxDataCacheSizeinMB set to 6,000.
Other values 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 application 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)