Last updated on MAY 15, 2017
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms