My Oracle Support Banner

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

Last updated on OCTOBER 18, 2019

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.