High Virtual Memory Usage By HsvDatasource.exe When Using Oracle Provider For OLE DB

High Virtual Memory Usage By HsvDatasource.exe When Using Oracle Provider For OLE DB [ID 761418.1]
		Modified 05-OCT-2010

---

Applies to:

Hyperion Financial Management - Version: 9.2.0.0.00 to 11.1.1.0.00 - Release: 9.2 to 11.1
Oracle Provider for OLE DB - Version: 10.1.0.2 to 10.2.0.4   [Release: 10.1 to 10.2]
Information in this document applies to any platform.

Symptoms

Virtual and private memory of the Hyperion Financial Management (HFM) application process, HsvDatasource.exe, continues to increase over time.

Cause

This issue is caused by a feature in the 10.2 and later Oracle Provider for OLE DB clients called Statement Caching and how Hyperion Financial Management uses its database connections.

Unpublished BUG 6827563 is submitted for this issue.

 

Solution

To resolve the high memory usage enable Statement Caching but set the configured value to a low setting, recommended value is between 1 and 10.

To implement this solution, Edit the following registry value:

Key:  Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb
Value Name:  StmtCacheSize 
Value (decimal): 1

Where, Key_Homename refers to the appropriate Oracle home.

Stop and restart the HFM application processes.