1. Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
  2. Monitoring EPM Cloud
  3. Activity Report Contents
  4. Essbase Statistics
  5. Essbase Metric

Essbase Metric

  • Number and Type of Oracle Essbase Operations Each Hour


    Section of the Activity Report that displays the number of Essbase operations performed each hour

  • Top 10 Longest Performing Essbase Data Extraction Operations
    Section of the Activity Report that shows the top ten longest performing Essbase data extraction operations

    Information in this table includes the start and end time, and cube from which data was extracted for each operation in the table. Depending on the total duration, you may need to evaluate and streamline these operations to improve performance.

  • Top 10 Longest Performing Essbase Data Load Operations
    Section of the Activity Report that shows the top ten longest performing Essbase data load operations
  • Top 10 Longest Performing Block Storage (BSO) Restructure Operations

    This table lists the type of each restructure operation and the name of the cube that was restructured.
    Section of the Activity Report that shows the top ten longest performing Essbase restructure operations

  • Top 10 Longest Performing Essbase Queries Over 15 Seconds

    Top 10 Essbase queries that took over 15 seconds to execute.
    Section of the Activity Report that shows the top ten longest running Essbase queries that took more than 15 seconds to finish

  • Top 10 Essbase Queries by Total Duration

    Top 10 Essbase queries that were executed for the longest durations and the cube against which each query was run.
    Section of the Activity Report that shows the top ten Essbase queries by duration.

  • Top 10 Essbase Queries by Execution

    Top 10 most frequently run Essbase queries and the cube against which each query was run.
    Section of the Activity Report that shows the top ten Essbase queries by execution

  • Max Number of Calculation Threads

    This chart shows the maximum number of calculation threads during any given hour.
    Table for maximum calculation threads per hour