EPM 11.1.2 - How to resolve high memory usage for HFM (Financial Management)
By Ahmed Awan-Oracle on May 16, 2012
If you use Oracle Database Client 10.2.x or 11.1.x for Financial Management, you must set the StmtCacheSize registry setting for Oracle OLE DB to 10 on all Financial Management application servers and Web servers. This is due to a memory issue in Oracle Provider for OLE DB. The registry setting path is: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb. Important Note that the 11.2.x Oracle Database Client should not be changed.
To resolve the high memory usage, enable Statement Caching. The configured value must not be zero. The recommended value is between and 1 and 10.
1. Edit the registry value: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb Value Name: StmtCacheSize Value (decimal):1, where Key_Homename refers to the appropriate Oracle Home.
2. Stop and restart the Financial Management application processes.