Slow Query in GElectic Extractor’s Change Detect
(Doc ID 2630315.1)
Last updated on JANUARY 22, 2020
Applies to:Oracle Utilities Network Management System - Version 184.108.40.206.0 and later
Oracle Network Management for Utilities - DMS - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
It seems like this AND condition of the GIS change detect query takes up a lot of time:
(FID_GEAR_NMS.CONNECTIVITY_N.Circuit1 IS NOT NULL OR FID_GEAR_NMS.CONNECTIVITY_N.Circuit2 IS NOT NULL).
Is this check required or can it be removed?
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