Issue: You use an Oracle database and want to improve the performance of Database Refresh.
Solution: Ensure that CURSOR_SHARING in Oracle is set to EXACT (the default setting).
Issue: You want to improve Planning, performance.
Solution: Tune WebLogic or increase heap size, depending on your environment. For example, if Java runs out of memory, and your server has more memory available than the 512 MB that is allocated to Java by default, you can increase the amount that Java can use. See “Increasing the JVM Memory Allocation” in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Note: | Oracle recommends working with a consultant to assess your environment. |