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

Last updated on MAY 15, 2017

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

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