My Oracle Support Banner

All Dimensions, Facts and Error tables Benig Analyzed Too Frequently (Doc ID 2266213.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.0.2 version, Outage Analytics

All Dimensions, Facts and Error tables Benig Analyzed Too Frequently
When the number of record modified is low, this stats gathering task is unnecessarily utilizing more database resources and impacting the performance

Steps to Reproduce

Follow below steps to reproduce the issue:
1.Start the load for all dimensions and facts.
2.Monitor the step 'Analyze Target table' for SCD1 and SCD2 dimensions. It executes for every load.
3. Monitor the steps 'Analyze Integration table' and 'Analyze Integration table for Error'. These steps executes for every load.

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
References


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