Gap Reports and Summary Reports Running For Excessive Amount of Time [Performance] (Doc ID 2289698.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Utilities Load Analysis - Version 1.11.0.5 and later
Information in this document applies to any platform.

Goal

Gap Reports and Summary Reports are taking a long time to run. Even if the ID’s in the query are restricted and if  the time frame is shortened (to one month or so) it still takes a long time to run.

For example, users are seeing that the reports are taking days to run to completion. The ID's in the query are restricted and if time frame for report is 1 month. In the CLDB, there are about a 18 months of daily cuts for approximately 25,000 AMI accounts.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms