1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Understanding the EPM Cloud Troubleshooting Process
  3. Reviewing the Activity Report to Identify Performance Bottlenecks

Reviewing the Activity Report to Identify Performance Bottlenecks

The Activity Report is generated automatically to help you identify issues that may impact the performance of your application.

A new Activity Report is generated in these three situations:

  • Every day during daily maintenance of the service
  • Each time you submit a Provide Feedback submission
  • Every time you execute the resetService EPM Automate command to restart an environment

For detailed information about the Activity Report, see Using Activity Reports and Access Logs to Monitor Usage in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Before contacting Oracle for help, especially for performance-related issues, review the Activity Report to identify bottlenecks. Specifically, carefully review the following sections of the Activity Report to identify areas that you may streamline to improve performance:

  • Number of Users: This section helps you determine if there is a correlation between the number of users and the performance of the application.
  • Top 7 User Interface Requests by Duration: This section, which identifies the top seven user actions by duration, provides you a starting point to identify why these actions take time to complete.
  • Top 30 Worst Performing User Interface Actions over 2 Seconds: This section, which identifies the worst performing actions and objects (for example, rule), helps identify artifacts that you need to evaluate to improve performance.
  • Top 10 Worst Performing Business Rules over 30 Seconds: This section identifies the business rules that take the most time to run, and are candidates for optimization.
  • Top 5 Worst Performing Calc Scripts Commands over 1 Min: This section identifies specific sections in a rule that takes a long time to execute and should be reviewed to improve performance.
  • Top 10 Worst Performing Essbase Queries over 15 seconds : This section list the worst performing Essbase queries, which may be optimized to yield better performance.