Knowledgebase: HFM
High Virtual Memory Usage By HsvDatasource.exe When Using Oracle Provider For OLE DB
Posted by Priya Doyle on 16 November 2010 01:22 PM
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.


(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: