1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Common Performance Issues

Common Performance Issues

The most common cause of poor performance is stale or missing table statistics. Oracle Hyperion Financial Management applications create new tables or can clear existing tables and reload or replace entire data sets on the fly. By default, Oracle 10g and 11g run nightly jobs to check for tables that need statistics to be updated. This may not be sufficient in some cases. The following activities are common end user activities where the DBA should be informed that schema statistics should be updated:

  • New HFM application created and loaded

  • Data in an existing Scenario is cleared and reloaded

  • New Scenario/Year is opened and loaded with data. This includes scenarios populated by Financial Management rules.

After a Scenario/Year has been loaded with the first month’s data, data loads to subsequent periods do not affect table statistics.