Determine an Integration's Typical Processing Times

You should know your integrations' typical running times so that you can more easily identify the integration instances that took longer than expected to run.

You have two options for checking processing times: review numerical times on the Instances page, or review graphical information on the Integrations page.

How Oracle Integration Calculates Duration

Oracle Integration calculates an integration instance's duration in the following ways:

  • Schedule integrations: Time that passes from start to finish.
  • Failed integrations: Time for all activities, including sending requests and rerunning the integration.
  • All other integrations: Time that passes between the triggering event and the flow finishing.

Option 1: Review Graphical Information

  1. In the navigation pane, click Observability, then Integrations.
  2. Hover over the row of an integration, and select View processing time statistics View processing time statistics.

    The Processing time panel opens. The panel shows the processing time for all integration instances for the integration.

  3. If needed, update the time filters at the top of the panel.
    The time filters appear at the top of the panel and to the right and include a drop-down filter and the ability to show data by the hour or by the day.

  4. Above the chart, select the following values to hide the lines for the values:

    • Minimum
    • Maximum
    • Standard deviation

    Only the Average value remains.

  5. Review the average processing times for the integration over time.

Option 2: Review Numerical Times

  1. In the navigation pane, click Observability, then Instances.
  2. Click Filter Filter icon, and update the filtering requirements for the page.

    For example, from the Sort by drop-down, select Duration. You might also want to update the time window filter.

  3. For each integration instance, find the Duration column, and review the value in the Duration field.